I have two plots with data selected from sheet 1. I set up the first plot to use a logarithmic x axis. When I added the second plot it is plotting versus row number rather than the x value I selected. What can I do to change this? Excel 2010
Dave Snelling
If you leave Excel's default horizontal alignment (General) alone, you could tell at a glance that some of the x values are text, because they align left.
Select column H, do Ctrl+H (Find & Replace) find: ~*10^ and replace with: E then press Replace All
Last edited by shg; 03-24-2014 at 05:51 PM.
Entia non sunt multiplicanda sine necessitate
Thanks shg. As you can tell I am a newcomer to Excel, but my usual Mathcad just cannot produce Journal quality plots so I must get used to Excel. I don't find Excel intuitive or easy to use, but experience and practice should help.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks