column graphs

[Jo]

Hi
How do I make a XY type column graph? I wish to add data
to a column graph and have it plotted at the correct X
interval
Thanks
Jo

 

[Tushar Mehta]

There's no easy way that I know of.

One option is to create enough empty spaces (rows) to get the correct effect. So, to plot x values of 1, 5 and 20, put the values in row 1, 5 and 20, leaving the other rows empty. Put the corresponding y values in the same rows (1, 5, 20).

Alternatively, create a XY Scatter chart and use a y error bar. Make it a 100% negative value bar. Format it for best effect, though about the best one can get is a thick line.