Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Charts sums 2 data series

Have 2 col of data and names 2 data series. But the second series is a total
of the first no. plus the second no. I want each col to be a separate line
on the chart.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 461
Default Charts sums 2 data series

Right click on the chart, choose Chart Type (or Change Chart Type
depending on Excel version), pick the first subtype, which is just
arbitrary series, not the second, which is stacked, or the third, which
is stacked to 100%.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Sig74462 wrote:
Have 2 col of data and names 2 data series. But the second series is a total
of the first no. plus the second no. I want each col to be a separate line
on the chart.

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
Flexibly specifying data series in charts hmm Charts and Charting in Excel 3 January 13th 08 03:38 PM
Drawing Order of Data Series on Charts Eddie McGlone Charts and Charting in Excel 1 September 6th 07 04:08 PM
Getting charts to automatically pick data from a series Salmonh20 Charts and Charting in Excel 3 April 8th 06 07:41 PM
How do I add the sums of a group of columns to a series in chart? Ron Charts and Charting in Excel 1 March 20th 06 11:48 PM
How can you add the same data series to all charts in a workbook MBubier Charts and Charting in Excel 3 January 30th 06 02:18 PM


All times are GMT +1. The time now is 11:19 AM.

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"