Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 226
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 226
Default 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




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default 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






  #5   Report Post  
Posted to microsoft.public.excel.charting
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






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Show Variance between 2 lines in Graph [email protected] Charts and Charting in Excel 5 April 23rd 23 07:43 PM
Powerpoint Graph- Shading in between two linear graph lines TerenYoung Charts and Charting in Excel 1 June 15th 06 09:29 AM
Do not show lack of data as a zero on graph lines, leave blank Just Joe Charts and Charting in Excel 1 February 15th 06 08:12 PM
How do I show break in bar graph to show large and small numbers GK Charts and Charting in Excel 1 December 19th 05 08:23 PM
Pivot shart referring to multiple sheets Kanga Charts and Charting in Excel 0 July 19th 05 11:28 AM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"