Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Can anyone help me with the attached chart? The first chart is how it currently looks, if you look at the small black section you can see it tapers off. however i would like it to look like the second chart and end abruptly in a straight line. Im using a combination of Line and Area charts. the data is in a 3 rows. Budget: cumulative Won: this only shows data in the past. (also cumulative) Forecast: only shows data in the future. (also cumulative) i.e month 1 | 2 | 3 | 4 Budget: 1,000|2,000|3,000|4,000 Won: 800|1,600| 0| 0 Forecast: 0| 0|2,000|5,000| Any ideas cos im stumped? +-------------------------------------------------------------------+ |Filename: Group-Forecast.-both.JPG | |Download: http://www.excelforum.com/attachment.php?postid=3454 | +-------------------------------------------------------------------+ -- jarvo ------------------------------------------------------------------------ jarvo's Profile: http://www.excelforum.com/member.php...o&userid=18983 View this thread: http://www.excelforum.com/showthread...hreadid=376299 |
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 | |||
How do I alter plot area colour in a chart without a mouse? | Charts and Charting in Excel | |||
excel chart area | Charts and Charting in Excel | |||
Setting custom chart causes plot area to collapse | Charts and Charting in Excel | |||
Area Chart Formatting Question | Charts and Charting in Excel |