Automatic Charting In Excel 2000

Post Your Computer Questions

Site Index | Quick Index | New Tips | MS Windows | MS Office | Newsletter | Q&A | More Tips |

Tips Download | Donations | Customer Support | Registry Tips | Weekend Windup | IE 6.0 | IE 7.0 | Help | Suggestions

Windows XP Run Commands | Computer Questions. | Microsoft Access Databases | Computer Terms | New Home Material Estimating Spread Sheets!

Windows XP Remote Desktop Setup One! | 57 Vista Run Commands | Windows XP Remote Desktop Setup Two!

See The 11 Tip Package That You Should Print And Keep Close To Your Computer!

100 Vista Tips!

This One Comes With The Standard Tips Package! Two Downloads!

Internet Fixes Computer Related FAQ. News Feed TOP 10 Questions Feed My Blog!

Have an IE 6, IE 7, Outlook Express, Windows XP or Vista Question? Click Here and post it.

Have a Windows 7 Question? Click Here and post it.

VIEW MY DAILY TIPS BY CLICKING HERE!

Automatic Charting In Excel 2000

Let's assume you're working in Sheet1 with column headings in row 1 and days in column A. Data relating to each date is in column B. Using Insert | Name | Define, type each name in the Names in workbook area, and then type the corresponding formula in the Refers to area. Click Add and type in:

Days=OFFSET(Sheet1!$A$2,0,0,

COUNTA(Sheet1!$A:$A)-1)

PlotData=OFFSET(Sheet1!$B$2,0,0,

COUNTA(Sheet1!$B:$B)-1)

Click on the series in your chart so the =SERIES formula appears in the formula bar. Edit the second and third arguments in the formula, replacing the reference to the column A range with the range name Days and the reference to the column B range with the range name PlotData. The result should be something like this:

=SERIES(Sheet1!$B$1,Book1!

Days,Book1!PlotData,1)

<<<Back Home Next>>>

Hit Counter

Main Site Navigation:

Have an IE 6, IE 7, Outlook Express, Windows XP or Vista Question? Click Here and post it.

Have a Windows 7 Question? Click Here and post it.

You Can also get all these tips plus more in one Package including 100 Vista Tips!


	Page 1	Page 2	Page 3	Page 4	Page 5	Page 6	Page 7	Page 8

See The 11 Tip Package That You Should Print And Keep Close To Your Computer!

100 Vista Tips!

This One Also Comes With The Standard Tips Package! 2 Downloads!

Internet Fixes Computer Related FAQ. News Feed TOP 10 Questions Feed My Blog!

Close To 400 More XP Tips. If you Can't Find The Answer Here just Click Here!
Page 1	Page 2	Page 3	Page 4	Page 5	Page 6	Page 7	Page 8

Newsletter Signup | Search | Windows Versions | Office Versions | Forum | Readers Q&A | Tips In Full Graphics | Tips Download

Site Navigation:
Donations | Support | Registry Tips | Weekend Windup | PC Questions | IE 6.0 | IE 7.0 | Outlook Express 6.0 | PC Help
Virus Info | Computer Drivers | Hardware Info. | Your Suggestions | IE 7.0 Install | Database Downloads | Home | Computer Terms

| 57 Vista Run Commands | Windows XP Run Commands | Microsoft Access Databases |

Windows XP Remote Desktop Setup One! |New Home Material Estimating Spread Sheets!| Windows XP Remote Desktop Setup Two!

All products mentioned are registered trademarks or trademarks of their respective companies.
Questions or problems regarding this web site should be directed to the Webmaster.
Copyright © 1999-2010 Internet Fixes. All rights reserved. Legal Disclaimer

This Site Is Part Of The Internet Fixes Network!