ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Can 2 graph lines show on same shart (https://www.excelbanter.com/charts-charting-excel/146195-can-2-graph-lines-show-same-shart.html)

Roger

Can 2 graph lines show on same shart
 
Can I show 2 sets of values on the same chart - e.g. sales in 2 months

David Biddulph[_2_]

Can 2 graph lines show on same shart
 
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




Roger

Can 2 graph lines show on same shart
 
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





David Biddulph[_2_]

Can 2 graph lines show on same shart
 
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







Roger

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








All times are GMT +1. The time now is 06:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com