XY Scatter with Column Chart

[brettmanning24]

Hello,

I have a XY scatter chart which has been created with different size
gaps on the x-axis. I would now like to add a column chart to my XY
Scatter. I can add the column chat but it does not align with the
points on the x-axis used by the XY Scatter, how can I do this?

Thanks

Brett

 

[Bernard Liengme]

I think you need to make a Line chart and then turn one (or more) data
series into column charts. The properties of an XY chart when the x spaces
differ make a combination impossible.
best wishes

 

[Mike Middleton]

Brett -

You might be able to get what you want by changing the Min, Max, and Major
unit for the XY data series. Click once on a point to select the data
series, and choose Format | Axis | Scale.)

You can see my example of Column chart type with XY (Scatter) chart type on
the Histogram page at http://www.treeplan.com.

- Mike
http://www.mikemiddleton.com

 

[Del Cotter]

I have a XY scatter chart which has been created with different size
gaps on the x-axis. I would now like to add a column chart to my XY
Scatter. I can add the column chat but it does not align with the
points on the x-axis used by the XY Scatter, how can I do this?

One of the freaky things you can do by exploiting the "Time axis" trick
for default category-based charts is changing the Category axis of a
column chart to Time-scale. This doesn't make the columns variable
width-- for that you have to fiddle with the area chart type-- but it
does make them variable *position*. However, the positions have to be
integers, and the maximum width of the column is 1 (when the gap width
in Options is set to 0. For higher numbers, it's narrower), so the more
integers you pack in to try to position them with precision, the
skinnier the columns get.

If you make a combination column chart with Time axis and XY chart, the
two types of series will be on different X- and Y-axes: one on First X
and Y axis and the other on Second. If you play with the scale
properties of the two axes, you should be able to get the dots of the
scatter graph to line up with the bars of the column graph. Don't forget
the Y axes also need to be lined up by hand, because they'll each adopt
their own most comfortable scale if you leave them on automatic.