Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 32
Default Stacked column graph

How do I add a data series as a line on a stacked column graph?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Stacked column graph

Add the series (as another column on the stack), select it, go to Chart menu
Chart Type, and choose a line type.


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Clare" wrote in message
...
How do I add a data series as a line on a stacked column graph?



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 90
Default Stacked column graph


I had the same question - but when I tried your suggestion it changed all
the data series into lines.
  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Stacked column graph

You need to select just the one series you want to change.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Debbie" wrote in message
...

I had the same question - but when I tried your suggestion it changed all
the data series into lines.



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
Stacked column graph Pat Charts and Charting in Excel 2 January 26th 08 01:28 AM
Creating a graph similar to a stacked column graph Jonathan Charts and Charting in Excel 6 August 4th 06 04:23 PM
How do you combine a stacked column and single column graph? Charlotte C Charts and Charting in Excel 1 December 3rd 05 01:04 PM
graph to compare one column with 2 others that are stacked Ellen Excel Discussion (Misc queries) 3 September 21st 05 08:29 PM
How to mix a stacked column and a clustered one on same graph? Armelle Charts and Charting in Excel 1 September 5th 05 01:40 PM


All times are GMT +1. The time now is 04:46 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"