LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jarvo
 
Posts: n/a
Default Area chart, help needed.


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
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
How do I alter plot area colour in a chart without a mouse? debbiecatal Charts and Charting in Excel 2 May 30th 05 04:11 AM
excel chart area Travis Charts and Charting in Excel 1 February 11th 05 09:40 PM
Setting custom chart causes plot area to collapse Chiara Charts and Charting in Excel 0 January 20th 05 05:32 PM
Area Chart Formatting Question Avrilon Charts and Charting in Excel 3 December 2nd 04 09:14 PM


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