Prev: how do I show a discontinuous chart axis
Next: Offset Horizontal axis data
From: SJL on 21 Apr 2010 04:52
Hi

I am creating a bat chart which will show a total score of e.g. 77%. I need
to know how to work out how to show the part 6 components play towards this
77%. The six components are 83, 96, 84, 49, 35 and 64. How can I calulate
this to show on chart please?
From: John Mansfield on 23 Apr 2010 02:21
Hello,

One option assumes the "total" score of 77% is really a target or average.
Set the data up like below and then build a combination column - line chart.
Series 1 would be your column source and series 2 would be the line source.
If a single score is better than 77%, the column tied to that score will
exceed the line.

Series 1 Series 2
83 77
96 77
84 77
49 77
35 77
64 77

--
John Mansfield
http://www.cellmatrix.net


"SJL" wrote:

> Hi
>
> I am creating a bat chart which will show a total score of e.g. 77%. I need
> to know how to work out how to show the part 6 components play towards this
> 77%. The six components are 83, 96, 84, 49, 35 and 64. How can I calulate
> this to show on chart please?
 | 
Pages: 1
Prev: how do I show a discontinuous chart axis
Next: Offset Horizontal axis data