Hi
I have two series - A and B - of data.
My data has later dates on top rows and earlier dates on bottom rows so when I plot the graph I format axis/categories in reverse order. This works fine until I change one of the series to secondary axis. When that happens, the graph plots wrongly.
Appreciate your help. I attach the file.
regards
L.Lee
Last edited by L.LEE; 12-31-2012 at 08:06 PM.
Hi L.Lee,
See the attachment and let me know if this looks fine now. thanks.
excel chart.xlsx
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi
Thanks for your response. I need the dates to go from Jan 2012 on the left to Dec 2012 on the right and for either Series A and B to be on the secondary Y axis.
regards
L.Lee
you can do so by using logarithmic scale on right side axis.. see the attachment.
excel chart.xlsx
Regards,
DILIPandey
<click on below * if this helps>
Is there a way to have Series B not on log scale? The red line also shows data starting from March 2012 whereas my data starts from Jan 2012.
HI Lee, without log, the series is not coming as the way you want
Regards,
DILIPandey
<click on below * if this helps>
Now I know what's wrong with this.... When I tried putting this on two axes, with a sensible y-axis, i could only see one data series. Your datasets are fully superimposable. So, I've changed some of the data and (now), I think that this is what you wanted...
I think one of the main problems here is that the dates are not truely dates and are being treated as text. That's the reason you have to reverse the data in order to get 1/Jan on the left.
edit the data in column A to convert to true dates. Then all you need do is move one of the series to the secondary axis. As Glenn points out the lines will overlay each other with the current data and default axes settings.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks