All
Wondering how to plot the attached data ..... was thinking something like a scatter plot but can't figure the better way to do....
TIA
shaz0503
All
Wondering how to plot the attached data ..... was thinking something like a scatter plot but can't figure the better way to do....
TIA
shaz0503
Hi,
Check the file.
Regards,
AM
Perhaps a 3D-plot?
Thanks for your responses....
I tried a 3D chart but would prefer the view the data in a view similar to scatter plot (quadrant) graph...
I have 'made' a sample of what I think I want..... but am unsure as to how to build.....
What do you think????
rgds
Your mockup looks like a basic bubble chart. I would start by recommending this tutorial from Excel's help files: https://support.office.com/en-us/art...rs=en-US&ad=US
Problem 1 -- Some of your data (especially column A and row 2 which contain the "x" and "y" data) are unusable text strings instead of real numbers. The first thing I would do would be to replace these text strings with real numbers (if you want to keep the original text strings, you can do this in a helper column and row). A3 becomes 0, A4 -- 1000, A5 -- 5000 and so on. B2 = 0, C2 = 20, D2 = 30 and so on.
Problem 2 -- A bubble chart wants the data in a list rather than a table like you have. The next step will be to arrange your data in the spreadsheet asWith real numbers for account balance and age, and the data arranged in a list, creating a bubble chart should be very straightforward.Please Login or Register to view this content.
Originally Posted by shg
thanks...
I will give this a go....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks