LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default special graph format

I need a graph type that's not standard in Excel.

suppose:
X axis =time in days
Y axis represent e.g. a production qty.
Each day on Xaxis has a target value T and a realized qty Q.
Q can be <T or =T or T.
So the graph will show 2 lines.
If T-line Q-line surface between Q and T must be red
If T-line < Q-line surface between Q and T must be red
For visual management it creates a graph; if you see surface green about
same size as surface green everage will be on target till that date.

Problem: I cannot find that type of graph in the excel graphs.
Does anyone know how to get it?

Huub


 
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
custom format changes to special Jan S[_2_] Excel Worksheet Functions 0 May 10th 10 11:56 AM
Paste Special/Format Kamron Excel Worksheet Functions 1 January 5th 10 02:36 AM
Need a special bar graph Keith Charts and Charting in Excel 3 August 19th 09 10:50 PM
Excel 2003. Custom format gets replaced by Special format. jasper New Users to Excel 0 September 1st 08 03:46 AM
How do I graph data daily as a line graph across a calendar format Glani Charts and Charting in Excel 3 November 23rd 07 09:05 AM


All times are GMT +1. The time now is 04:09 PM.

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"