Chart X/Y is 90 degrees out

J

John Castle

I want to create a simple chart with project milestones as
the Y axis and dates (months) as the x axis. I will then
plot a series across the chart showing milestone
completion dates. I have set this up using a line chart
but the Milestones are on the x axis and the months on the
y axis! How do I configure the chart to be the right way
round??
 
J

Jon Peltier

John -

You have to use an XY Scatter series for the milestone markers, with
appropriate X and Y values. The XY chart will use the secondary axes;
scale these so the secondary X axis matches the primary Y axis, and so
the markers line up with the appropriate bars.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 

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

Similar Threads

Dynamically Scale X Axis on Column Chart Based on Number of Catego 1
Still have probs with Milestone Chart 2
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Chart distorts secondary axis when the x-axis is logarithmic 5
A line chart 3
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Using the full width of an Excel chart with two Y-axes 2
Positioning x axis at bottom of chart with negative values 5

Top