Adding data series

[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.

 

[dvt]

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.

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

 

[Meredith]

Thanks so much dvt, it worked fine. I see you are from
psu. I'm a recent psu alumni.