Hi Experts
what is the best chart to represent the value to show it below and above target ?
Hi Experts
what is the best chart to represent the value to show it below and above target ?
May be as 2 separate series for below and above target? And as above target are significantly shorten than below - different scales? See attached. Below graph are calculations of values used to setup limits and units for axes.
Best Regards,
Kaper
The first part is quite obvious. As the time in excel cannot be negative, the formulas in C2 and D2 are respectively:
andFormula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
and copied down.
Now there is in columns C:D data for two series.
max values are 3 hours+ for below limit and 6 minutes above limit. The graph is preppared that way (see attachment):
step 1 column graph form C and D
step 2: 2nd series drawn in secondary axis
step 3: manual axis limits. For primary between -4 and 4 hours, for secondary between -8 and 8 minutes
because for columns C and D we have max values of 3:17 and 00:06
as we want "easy to see values, we will divide axis for C column into 8 half hour lengths (7 would be enough too),
and to maintain "fit" between primary and secondary axes for data in D we will set axis between -8 and 8 minutes (one minute lengths)
the division into half hour and one minute will be done in next step
step 4: division into appropriate legths between labels on both aves, main axis in reversed order
The numerical values for 1 minute, 8 minutes, 1/2 hour and 4 hours are calculated in L30:Q32
See attached file.
Hope it is clear now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks