Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
h3nry5
 
Posts: n/a
Default Want chart to stop rather than goto zero


Hi,
I have five and a half years of data that I am trying to plot using an
area graph. My problem is that after the half year the data drops to
zero, which makes it look like the year's results are dropping like a
stone. Is there anyway to get the graph to just stop and go flat rather
than move down at a diagonal to zero?
Thanks,
H3nry5.


--
h3nry5Posted from http://www.pcreview.co.uk/ newsgroup access

  #2   Report Post  
bj
 
Posts: n/a
Default

if your data is in rows (Say row 6
set up your initial series as in C6 =B6. in D1 =C1 etc.
As you enter data write over the top of the equaition with your data.

"h3nry5" wrote:


Hi,
I have five and a half years of data that I am trying to plot using an
area graph. My problem is that after the half year the data drops to
zero, which makes it look like the year's results are dropping like a
stone. Is there anyway to get the graph to just stop and go flat rather
than move down at a diagonal to zero?
Thanks,
H3nry5.


--
h3nry5Posted from http://www.pcreview.co.uk/ newsgroup access


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
Urgent Chart Assistance Brent E Charts and Charting in Excel 1 May 10th 05 09:09 AM
Urgent Chart Questions Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
Urgent Chart Assistance Requested Brent E Excel Discussion (Misc queries) 0 May 9th 05 11:01 PM
How to chart start and stop times tresscott Charts and Charting in Excel 1 April 10th 05 11:04 PM
How do i stop the colors changing on my pivot chart when i refres. kev from uk Excel Discussion (Misc queries) 1 March 2nd 05 01:51 PM


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