How do I change X-Axis values in a chart with 2 Y-Axis?

E

ESGLCC

I am attempting to chart two data series that share a X-Axis. The Y-Axis for
these series are at different ranges so I have two Y-Axis. When I do this
the X-Axis turns into a non-numerical entry, example, 1-2-3-4, when my data
is a time and is organized as this (15-30-60-90...etc.) Is there a chart
with two Y-Axis and one X-Axis with the plot showing the appropriate spacing
that I require? I am using Excel 2002 if that changes anything
 
B

bj

when You go to <chart><Chart data><series> does it show two different x data
sets? if your x axis lables were on the set you changed to the secondary Y
axis, it may not be showining up on your primary X axis.
also goto <chart><chart options><axis> and select second x axis
is this a XY or line chart?
 

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

Make Y-axis values correspond to x- axis value 1
Scatter chart with categories on x-Axis 2
Use text descriptors as Y axis units 1
Excel 2010 - Line Chart with Mulitiple Data Sets 1
One extra x axis item that wont go away - can anyone help? 3
Chart distorts secondary axis when the x-axis is logarithmic 5
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1

Top