Excel chart with column and line

D

Don Niall

Hi,

I am preparing a graph. There are two chart-types being
shown - column and line, but they are associated.
The X-axis shows 'calendar quarters' while the Y-axis
shows $USD. The number of column graphs for each quarter
can be 1 or 2. For example, in Q1 I have a single column
graphs in Q2 2..... I have just a single line graph.

My problem is that since the number of column graphs
varies the markers for the line graph appear 'offset',
which from a visual perspective looks confusing. The
marker only appears aligned properly for those quarters
that have 2 column graphs.

Is there anyway I can manually align the column graphs
with the markers on the line graph (ie force the marker to
the mid-point of the column).

Would appreciate your help!

Don -
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top