L
Leslie
With much help from persons in this newsgroup, I have been limping towards producing a particular chart. I am having so many problems, though, that I'm now wondering whether I've made an fundamental error in using the data range I'm using. I'll explain it below and would be most grateful for any advice about it.
I'm trying to produce a column chart in which three of the nine columns are stacked and the rest are just a single data series each.
My data range consists of numbers only (no text) and looks on the screen like a staircase viewed side on, with the steps going down from the top left to the bottom right.
Where the relevant column is just a single data series, the step is just a single cell wide. However, where the relevant column is stacked the step is as many cells wide as the number of stacks.
To illustrate, the numbers look like this:
x
x
xxx
xx
x
That has produced a chart which, as far as it goes, is what I want.
However, my latest problem with this data is trying to add value data labels to each of the columns. Obviously, there is no problem with those columns which are just a single data series. However, where the column is a stacked one, trying to show a total value of the stacks in the column has been beyond me.
I tried to solve the problem by adding to the relevant data series another series whose value was the same as the total value of the stacks, adding a value data label to it and then making it transparent, leaving the data label behind and visible. For some reason I can't understand, doing that, which did work for the relevant column, made other columns appear distorted. Thus, an adjacent column which was supposed to have a value of, say, three, says it has that value when I slide the cursor over it, but appears on the screen below the gridline for 3.
It's really that which has made me question the form of my whole data range.
As I say, any advice would be much appreciated.
I'm trying to produce a column chart in which three of the nine columns are stacked and the rest are just a single data series each.
My data range consists of numbers only (no text) and looks on the screen like a staircase viewed side on, with the steps going down from the top left to the bottom right.
Where the relevant column is just a single data series, the step is just a single cell wide. However, where the relevant column is stacked the step is as many cells wide as the number of stacks.
To illustrate, the numbers look like this:
x
x
xxx
xx
x
That has produced a chart which, as far as it goes, is what I want.
However, my latest problem with this data is trying to add value data labels to each of the columns. Obviously, there is no problem with those columns which are just a single data series. However, where the column is a stacked one, trying to show a total value of the stacks in the column has been beyond me.
I tried to solve the problem by adding to the relevant data series another series whose value was the same as the total value of the stacks, adding a value data label to it and then making it transparent, leaving the data label behind and visible. For some reason I can't understand, doing that, which did work for the relevant column, made other columns appear distorted. Thus, an adjacent column which was supposed to have a value of, say, three, says it has that value when I slide the cursor over it, but appears on the screen below the gridline for 3.
It's really that which has made me question the form of my whole data range.
As I say, any advice would be much appreciated.