I'll have a look to see if there's a way to make the Wizard work more intelligently the first time round. Granted, this does take a little bit of work, but it doesn't require editing every single data point. The x axis scale then changes to 0-100, which seems much more sensible. In my case, I had your "NAMES" in Col A, and it used Col A as the source for the X axis values, which is obviously wrong.īut it's easy to change - just edit the source ranges for both the X and Y values. After you selected the chart, you will get the chart next to your excel data table. Source: Advanced graphs using excel 3dhistogram in excel with. After you have opened up the excel program fill out the data you would like to create a scatter plot of. Then, for the remaining one, see where it's taking the X and Y values from - it's taking them from the wrong columns. 3d scatter plot for ms excel scatter plot plots chart. You can simply select the second one and remove it. When you do this, you can see what's going wrong. To correct this, I opened the Chart dialog box, and selected the Source Data option. I used the chart wizard to knock up a quick XY chart, and sure enough, the X axis scale went from 0 to 10, which bears no relation to what you think are the X axis values. I'm not sure I understand your problem correctly, but if I do, there is a relatively easy fix, which does not require editing each data point.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |