Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Nicola
 
Posts: n/a
Default How do i add a line graph onto a stacked column chart using data

I have a stacked colum chart showing the make up of total with 3 variables
I need to then add a line overlaying this showing expenditure and have no
idea how to do this- can anyone help I can'tfind it in general help
  #2   Report Post  
bj
 
Posts: n/a
Default

plot the expenditure data as one of the stacked column data sets
select just that data on the graph and <chart<Chart type select the line
chart
it will only change the one data set.

"Nicola" wrote:

I have a stacked colum chart showing the make up of total with 3 variables
I need to then add a line overlaying this showing expenditure and have no
idea how to do this- can anyone help I can'tfind it in general help

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
graph to compare one column with 2 others that are stacked Ellen Excel Discussion (Misc queries) 3 September 21st 05 08:29 PM
Having trouble plotting blanks on a line graph duncanm Charts and Charting in Excel 1 September 14th 05 03:28 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
Possible to Add Horizontal Line to Embedded Graph via VBA? TimSchwaar Charts and Charting in Excel 5 August 29th 05 11:41 PM
How do you fit a line to a graph? lonschlong Excel Discussion (Misc queries) 1 April 8th 05 04:49 AM


All times are GMT +1. The time now is 07:41 PM.

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"