+ Reply to Thread
Results 1 to 6 of 6

Better way to present data graphically

  1. #1
    Forum Contributor
    Join Date
    12-06-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    139

    Better way to present data graphically

    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
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    03-11-2014
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    379

    Re: Better way to present data graphically

    Hi,

    Check the file.

    Regards,
    AM
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-14-2004
    Location
    Jämtland, Sweden
    Posts
    16

    Re: Better way to present data graphically

    Perhaps a 3D-plot?
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-06-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    139

    Re: Better way to present data graphically

    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
    Attached Files Attached Files

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Better way to present data graphically

    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 as
    Please Login or Register  to view this content.
    With real numbers for account balance and age, and the data arranged in a list, creating a bubble chart should be very straightforward.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  6. #6
    Forum Contributor
    Join Date
    12-06-2012
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    139

    Re: Better way to present data graphically

    thanks...

    I will give this a go....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to graphically select a subset of points on an XY Scatter Chart?
    By geophysicist in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-20-2013, 12:29 AM
  2. [SOLVED] Auto Hiding rows based on range/data present or not present.
    By raze in forum Excel Programming / VBA / Macros
    Replies: 27
    Last Post: 02-10-2013, 11:27 AM
  3. [SOLVED] How to show a ratio (13:1) graphically
    By mebirkle in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 07-24-2012, 01:05 PM
  4. Macro or function to graphically map out cell precedents?
    By Nickster64 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2008, 08:22 PM
  5. [SOLVED] I am trying to show graphically employees working 8:30 am to 6:00
    By mikiebigm in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-23-2006, 10:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1