Stacked Column Chart Question...

  • Thread starter Thread starter Chess-set
  • Start date Start date
C

Chess-set

Hello,

Could someone tell me if its possible to have a stacked column chart o
a variable x-axis?

I ask because I have a scale on the x axis - distance - and I'd lik
each stacked column to appear at the correct distance.

Currently all I'm able to achieve is..

eg.

| 5 | 10 | 20 | 50 | <--- x-axis

What I want is this..

eg.

1 2 3 4 | 5 | 6... etc (where ||'s denote
column).

Any help would be greatly appreciated :
 
Try to populate a sparse range in the worksheet, putting every X value
in its row even if there's no corresponding Y:

MyData
1
2
3
4
5 50
6
7
8 70
9
10 75

This will space the columns according to the category number. You will
find that the columns may look like a set of skinny lines if you have
lots of categories, because the column cannot be wider that the space
for the category.

- Jon
 
Back
Top