Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
ahaigh
 
Posts: n/a
Default Adding lines of data to an area chart


Hi,

I have an area chart that has a timeline as the x-axis (ie # of days)
and a % as the y-axis.

I'd like to be able to add a data series onto the chart as a line
rather than have it make up part of the area chart. (I'd effectively
like the area chart to act as a background and to overlay multiple data
series as lines over the top)

Am I making sense? Could anyone suggest how this could be done?

Thank you,

Al


--
ahaigh
------------------------------------------------------------------------
ahaigh's Profile: http://www.excelforum.com/member.php...o&userid=32414
View this thread: http://www.excelforum.com/showthread...hreadid=554217

  #2   Report Post  
Posted to microsoft.public.excel.misc
SAR
 
Posts: n/a
Default Adding lines of data to an area chart


Use the 2Y axis for your line chart and set the numbers on the 2Y axis
accordingly so the lines fall where you want them to. 2Y formatting is
separate and apart from Y.


--
SAR
------------------------------------------------------------------------
SAR's Profile: http://www.excelforum.com/member.php...o&userid=34172
View this thread: http://www.excelforum.com/showthread...hreadid=554217

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
How do I shade the area between two lines on a chart? Hart Charts and Charting in Excel 4 April 3rd 23 04:29 PM
Create single chart with data from seperate worksheets MATT Charts and Charting in Excel 1 May 10th 06 04:09 AM
Can I use data from different worksheets to create a chart Dona Charts and Charting in Excel 2 March 14th 06 01:47 AM
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 01:56 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM


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