Adding data series

  • Thread starter Thread starter Meredith
  • Start date Start date
M

Meredith

I currently have a graph made with both a primary and
second axis, I would like to add a third data series to
this graph that would go along the primary axis...is
there anyway I can just add a column in my spreadsheet
and have it appear on my graph so I don't have to format
and make a whole new graph? Thanks in advance.
 
Meredith said:
I currently have a graph made with both a primary and
second axis, I would like to add a third data series to
this graph that would go along the primary axis...is
there anyway I can just add a column in my spreadsheet
and have it appear on my graph so I don't have to format
and make a whole new graph? Thanks in advance.
Click to expand...

It's not *quite* that easy...

Add the column to your spreadsheet. Right-click on the chart, select Source
Data. Select the Series tab. You should see your two data series
represented in the dialog box. Click Add to add another data series. Put
the appropriate ranges in the X or Y value boxes. If the preview in the top
looks right, click OK and you're finished.

Dave
dvt at psu dot edu
 
Back
Top