column graphs

  • Thread starter Thread starter Jo
  • Start date Start date
J

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
 
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.
 
Back
Top