PC Review


Reply
Thread Tools Rate Thread

Charts sums 2 data series

 
 
Sig74462
Guest
Posts: n/a
 
      2nd Oct 2009
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 With Quote
 
 
 
 
Jon Peltier
Guest
Posts: n/a
 
      2nd Oct 2009
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Report Sums of Sums SNCONC Microsoft Access Reports 1 31st Mar 2009 01:22 PM
Charts switch from 'Series in Rows' to 'Series in Columns' Peace Microsoft Excel Charting 4 22nd Mar 2007 04:52 AM
How to add previous sums in a column to current sums in a column? =?Utf-8?B?VEQ=?= Microsoft Excel Worksheet Functions 1 30th Sep 2006 02:55 PM
How do I add the sums of a group of columns to a series in chart? =?Utf-8?B?Um9u?= Microsoft Excel Charting 1 21st Mar 2006 12:48 AM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Microsoft Excel Charting 3 30th Mar 2005 06:23 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:25 AM.