View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Roger Roger is offline
external usenet poster
 
Posts: 226
Default Can 2 graph lines show on same shart

Many thanks for the full explanation David, I persisted and worked it out for
myself 2 minutes ago. I think the extreme tiredness from antibiotics for a
tooth abscess are affecting my thinking today. Thanks again for your help.

"David Biddulph" wrote:

Chart menu/ Add data/ Select the data range for your new series/ At an
appropriate stage of the wizard, tell it to add as a new series, rather than
as new data to an existing series.

Or

Chart menu/ Source data/ Add ...

Or

Copy the new series from your data sheet/ Select your chart/ Edit/ Paste
special/ As new series

Or ...
--
David Biddulph

"Roger" wrote in message
...
Thanks for confirming David, but I could not see how to achieve it. I did
try
myself, and scanned through the Help topics but without success. It is
easy
to add extra observations in the same curve, but could you please guide me
briefly on extra data series. Thanks in anticipation.


"David Biddulph" wrote:

Yes. Up to 255 data series in one chart.
--
David Biddulph

"Roger" wrote in message
...
Can I show 2 sets of values on the same chart - e.g. sales in 2 months