Column + Scatter Graph

  • Thread starter Thread starter Adapted
  • Start date Start date
A

Adapted

Hey,

I'm trying to create a combination of a column and scatter graph. I ca
create both individually without a problem. But when I try and combin
them I have problems with the scale of the x axis.


The scatter graph bit looks as it should, but the columns are crunche
up to the left of the graph. I believe its something to do with th
scatter graph using the actual values while the column chart i
treating it as something else. (Sorry its so hard to explain - I thin
I'm refering to a similar difference that exists between scatter an
line graphs and how they treat the x axis value).


I basically want each column of the chart to line up with th
corrosponding point of the scattergraph. Is this even possible?

(A picture of how it looks is below).



If this isn't possible - could you suggest the best way to represen
the data (perhaps one graph below the other?).

Thanks

Attachment filename: graph.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=40589
 
If that is indeed a XY Scatter chart (and not a line chart), consider
converting it into a Line chart -- if that would be appropriate to your
data set.

Alternatively, put the XY Scatter chart on the secondary x- and y-axes.
Double-click the scatter chart, from the Axes tab select 'Secondary.'
Then, with the chart selected, select Chart | Chart Options... | Axes
tab and check on the 'Secondary x axis'.

If, on the other hand, you have a Line chart already (which is what I
suspect), with the chart selected, select Chart | Chart Options... |
Axes tab. In there, specify the type of the x-axis to be Category and
not Automatic or 'Time scale.' Hopefully, this format will be
appropriate to your data.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thanks for the attempt to help, but I guess my explainination was to
vague :(

Attached should be a picture of how everything should look. The onl
problem being that the scale on the x axis is non-existant. The scatte
graph's 'points' are all equally spread out on the x axis rather tha
how they should be.


I hope this helps to explain my problem a tad better

Attachment filename: graph2.gif
Download attachment: http://www.excelforum.com/attachment.php?postid=40621
 
Do go over my original post again.

If you want a XY Scatter chart with a column chart, your only choice is
to put the XY Scatter chart on the secondary axes.

You can format the result to achieve some degree of aesthetic appeal,
but XL cannot show a XY Scatter chart and a column chart on the same
set of axes.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Thankyou

I must have missed out a step the first time round.

I've progressed with the chart, however - Im curious as to whether yo
can manipulate the space between the 'bars' on the chart? (Namely so
can match both the scatter graph and the column chart up as close as i
possible).

I feel this should be possible - as if you set the axis to being
timescale the space between the 'bars' change
 
Yes, alignment between a scatter chart and a column chart can become an
issue. You can adjust the min/max values of the scatter chart axis.
To adjust the width between the bars, in the chart double click the
column series, then select the Options tab.

You may also want to experiment with the 'Y axis crosses between
categories option of the x-axis. Double-click the x-axis, then select
the Scale tab.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top