adding to a graph
 

I have a graph which is connected to a 2 column table.
I have added another column to the table.
How do you get the graph to plot the 3rd column from the table without
redoing the graph?
My graph will have 2 lines and one column to represent the data.
Thanks

adding to a graph
 

Select the new data; copy it
Click the chart to activate
Use Edit | Paste Special and specify New Series
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Charles Eaves" wrote in message
...
I have a graph which is connected to a 2 column table.
I have added another column to the table.
How do you get the graph to plot the 3rd column from the table without
redoing the graph?
My graph will have 2 lines and one column to represent the data.
Thanks

adding to a graph
 

Thanks.
I will give a try in a little bit.
Thanks again
"Bernard Liengme" wrote in message
...
Select the new data; copy it
Click the chart to activate
Use Edit | Paste Special and specify New Series
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Charles Eaves" wrote in message
...
I have a graph which is connected to a 2 column table.
I have added another column to the table.
How do you get the graph to plot the 3rd column from the table without
redoing the graph?
My graph will have 2 lines and one column to represent the data.
Thanks