Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 78
Default Additional Series on two x

I have a simple columns chart with two series stacked on top of each other.
(different colors with values inside)

I would like to add a third series in form if a line which would be the
total of the two values

Can I do this and how? Thank you
--
Felix
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 396
Default Additional Series on two x

First calculate the values for that 3rd series (the sum of the other 2 series).

Then plot the series on the chart.

Then click the 3rd series in the chart and change the series to a line.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Felix" wrote:

I have a simple columns chart with two series stacked on top of each other.
(different colors with values inside)

I would like to add a third series in form if a line which would be the
total of the two values

Can I do this and how? Thank you
--
Felix

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
Fill Series Dates: not letting me change the series from year to m Mike Excel Discussion (Misc queries) 1 January 24th 08 05:08 PM
How to overlay(?) additional data on a series DavidJ726 Charts and Charting in Excel 7 April 25th 06 05:02 PM
Additional series without legend GeorgeAtkins Charts and Charting in Excel 2 December 25th 05 08:49 PM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM
series graph -- one series being added to another series rich zielinski via OfficeKB.com Charts and Charting in Excel 3 March 30th 05 06:23 PM


All times are GMT +1. The time now is 09:55 AM.

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

About Us

"It's about Microsoft Excel"