plotting line graph with 2 x values

[Jase]

I am trying to plot a line graph. For my X data I am using days such as 20,
35, 52 etc. Those days also have a name such as july, august, september. On
my graph I want to plot the actual numbers but have my label points show the
months name. Is this possible?

 

[Luke M]

Yes, you need to add a dummy series however. For now, make it 12 points,
each with a value of 1. HAve these correspond to your months (Jan, Feb,
March, etc). Add this series to your chart.

Now, format your original series, under axis, move to secondary axis. 'ok'.
Right-click on chart, under chart options, activate the secondary x-axis.
'hit okYou may need to fiddle with it a bit at this point, but at this point,
under source data, set it up so that the dummy series (which is currently
primary series) is using the month labels as its x-axis labels, and your true
data (now secondary series) is using the numbers.

If things are working so far, you should see the numbers on top of chart,
and labels on bottom. Format the top-axis so that tick marks/labels are not
visible. Format the dummy series so that both line/markers are not visible.
If you have a legend, click on legend, then single click on label for your
dummy series, and hit 'delete'. You should now have what appears to be a
chart with just a single series, plotted against month labels.

 

[Jase]

This was very helpful, thank you. However sometimes I use logarithmic
scaling, am I still able to do this?

thanks,

jase

 

[Jase]

Also all my points are evenly spaced after I do this where as before i have
some dates that are 20 days apart and some that are 150 days apart so its
giving me a false visual.

thanks,

Jase

 

[Jase]

I figured it out, you can just click on each individual data label and
refernce the cell you want from there.