Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I shade the area between two lines on a chart? | Charts and Charting in Excel | |||
Create single chart with data from seperate worksheets | Charts and Charting in Excel | |||
Can I use data from different worksheets to create a chart | Charts and Charting in Excel | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions |