View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default plotting in excel 2007

Unfortunately Dumbledore is dead. The Office design group knows better than
we how we use their products.

Before you insert the chart, select the data you want plotted, or just the
data for one series. Then you can struggle with the new source data dialog.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Kevin" wrote in message
...
I'm having difficulties making graphs in 2007, mainly because when i hit
the
insert graph button excel says "i'll take it from here" and proceeds to
make
a graph of damn near the whole sheet which may contain 30-40 thousand data
pairs. Is there no way to go back to the old wizard that let YOU pick what
data you want to graph rather than Mr. Gates? I know that i can click on
a
location in the sheet where there's no data anywhere near it and it'll
just
open an empty plot but that shouldn't be the only way.