Hello,
I am trying to create a scatterplot similar to the one attached (Scatterplotexample)
Instead of plotting arm strength against grip strength, I am plotting tree diameter (10-19, 20-29, 30-39, and 40-49) against tree age (30-80 years).
When I plot my data (as shown in My_data_scatterplot), The x-axis is tree age (which is what I want) but the y-axis is only plotting the number of trees that are that age.
I want to create a scatterplot has the y-axis representing diameter categories(10-19, 20-29, 30-39, and 40-49).
So that when you look at the chart you would see 4 separate scatter points at 30 years of age (x-axis) clustered at the 10-19 diameter mark (on y-axis).
Is this possible in excel 2007? I have tried arranging my data differently but have yet to get the chart I am seeking.
Thanks in advance for any help/advice!
If you want 4 points you will need 4 pieces of data. You will also need to vary the x and or the y values otherwise the 4 markers will all appear in the same place and still look like 1 marker.
Bascially chart plot the information provided. They do not summarize or breakout your data. You need to do that with formula or code and then plot the results.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks