View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default I need help with charts in Excel 2007

They changed a lot of stuff in 2007. The light borders around the data
ranges (which you reported not seeing) is still there. Instead of the Source
Data dialog, you have to go to Chart Tools Design tab Data group
Select data. Select a series by name in the left hand list, and click Edit.
This brings up the Edit Series dialog, which has entry boxes for series
name, X values, and Y values.

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


"Movemout" wrote in message
...
I have beeen to your web site and have been trying to follow your charts
how
to. I have found the section about source data and I am guessing that what
I
need is the Series tab which I dont seem to be able to find in Excel 2007.

"Jon Peltier" wrote:

Select the data in row 2, then hold CTRL while selecting the data in
another
row, and insert your chart.

Alternatively, create your chart, and on the Chart Tools Design tab,
choose Change Data, and change the reference from row 3 to row whatever.

Or select the series, locate the thin blue outline in the worksheet which
indicates the selected series' Y values, and drag the outline to the
appropriate row.

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


"Movemout" wrote in message
...
I need help with inserting dates on the axes. I have dates as my column
headings on my worksheet in row 2. I am trying to create a chart using
the
dates and just the data I have entered in a particular row, say row 12.
It
works fine if I chose line 3, but I need to create charts using other
lines.
Is this possible?