Perplexing Chart Question

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I went here

http://support.microsoft.com/kb/183446

and followed the instructions exactly to create a chart in a new sheet
that automatically updates for 2007--it worked perfectly.

When I tried to do the same thing with existing data I could never get
it to work, and I tried ten times.

I have no idea what I'm doing wrong. Any suggestions?
 
Hi Jim,

I haven't check Microsoft step by step instructions but if the data range
you are working with grows or shrinks in the vertical direction, there is a
simpler way to handle this. What the web site is suggesting is using
dynamic range names - for a horizontal list that's fine, for a vertical
list -

1. Select the data source including titles
2. Choose the command Home, Format as Table, OK.
3. Build your chart from the table range and as you add new data the chart
will automatically expand.
4. If you don't like the table formatting of autofilters you can remove the
formatting and turn off the auto filters.

Cheers,
Shane Devenshire
Microsoft Excel MVP
 
Back
Top