Non-standard bar chart

  • Thread starter Thread starter andymarbles
  • Start date Start date
A

andymarbles

im doing a bar chart, but I want to treat the x axis labels
numerically.

so let's say the data looks like

income frequency
£500 2
£1000 3
£2000 2

so rather than 3 evenly spaced bars labelled with 500, 100 and 2000, I
want a space between 1000 and 2000 with nothing in it. does that make
sense? ive done it before but can't remember how. ive got a feeling
it's via a non-standard chart typw
 
500, 1000, 2000 in A1:A3
2, 3, 2 in B1:B3
In C1:C2, put 500 and 1000, select and drag until C4.
Erase 1500
In D1, paste :
=VLOOKUP(C1,$A$1:$B$3,2,0)
and drag down.
Create your chart with data in C1:D4.
Regards.
Daniel
 
Back
Top