Chart HELP!!

  • Thread starter Thread starter saturnin02
  • Start date Start date
S

saturnin02

Hi,
I'm still working on my chart problem.
I must be stupid but...for example,
say I have a series 1,2,3,4 and I want that series in ONE BAR only,
cumulative, that is one bar section going from 0 to 1, next section of SAME
bar going from 1 to 2, next section of SAME bar going from 2,3 etc. so that
at the end I have ONE bar, not 4 bars.
Tx a lot.
Sat
 
You need to do a stacked column chart. Be aware that you
may need to view it by columns OR by rows to achieve the
desired effect. If you have the data running in a column
you need to view the data as rows and vice versa if your
data runs left to right in a row.
hth
Kevin M
 
Kevin,
Please give me more details.
In a stacked column, it WAY OVERSHOOTS the upper number.
For example, my max number is 1,500,000 and it overshoots so that it looks
like it is 3,000,000 on the y axis.
How do I get the bar to just come up on y axis to the 1,500,000 number and
not overshoot?
Tx,
S
 
S -

In a stacked column/bar chart, each element illustrates the difference
from the top of one bar to the top of the next. So you need to subtract
a running sum from each total value to get what the height of the
current bar should be.

- Jon
 
S -

In a stacked column/bar chart, each element illustrates the difference
from the top of one bar to the top of the next. So you need to subtract
a running sum from each total value to get what the height of the
current bar should be.

- Jon
 
Back
Top