LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Graph with stepped increases or decreases

I would like a graph which reflects the true position of inventory/goods on
hand. Currently we have a line graph with quantity on the x-axis and dates on
the y-axis. The problem is that the if you have 30 units on the 1st May and
then 50 units come into store on the 15th May the line joining the two points
is a slope which incorrectly shows stock increasing consistently from the 1st
of May until the 15th of May. The correct graph would show a line of 30 units
along the period 1st to 14th May and then jump to 80 units on the 15th May.
Is there a graph type which reflects this situation?

Thank you for your assistance.
 
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
Conditional Formatting - Increases/Decreases Paul Lambourne Excel Discussion (Misc queries) 4 October 28th 08 03:03 PM
How can I increase value in one cell as value in other decreases? Liz Parkes New Users to Excel 5 November 22nd 07 01:03 PM
Stepped Functions Gary T Charts and Charting in Excel 2 June 14th 05 11:13 AM
Stepped fee calculation Betty Csehi Excel Discussion (Misc queries) 2 May 27th 05 09:53 PM
Generate a smooth curve from uneven data points in a "stepped" co. [email protected] Excel Worksheet Functions 1 December 29th 04 02:07 AM


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