+ Reply to Thread
Results 1 to 3 of 3

Graph displaying the wrong information

  1. #1
    Registered User
    Join Date
    12-08-2017
    Location
    Plymouth, UK
    MS-Off Ver
    15.4
    Posts
    2

    Graph displaying the wrong information

    Hi all,
    I'm struggling trying to find a solution for the following problem and was wondering if one of you could help.

    For part of my dissertation I have to observe the locations of schooling fish within a fish tank, which is divided up into 8 sections (T1 - T4 for the top sections of the tank and B1 - B4 for the lower sections of the tank). Once per minute I need to record how many fish are in each section.
    My table has "minutes" plotted in the left column and "sections" plotted along the top row.

    Whenever I try to create a bubble graph from this information it treats the "sections" as series rather than plotting them on the Y axis. "Minutes" are displayed correctly in the X axis.

    All the solutions I have found so far have had no effect on the outcome of my graph. I have also tried using other graphs and I'm getting the same result.

    I've dropped a copy of one of the tables here

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,897

    Re: Graph displaying the wrong information

    Your file does not include any examples of the charts you have tried. It might help us better understand your question to see what you have tried, with an explanation of why it is unsuitable.

    I find that a lot of charting questions are often more about arranging data in the spreadsheet rather than creating the actual chart. The arrangement you have should be good for creating a scatter or line or column or bar chart, but it will not work well for a bubble chart. In order to create a bubble chart, I would change the arrangement of the spreadsheet to a list rather than a table like you have:

    Please Login or Register  to view this content.
    The number in the second column is just an arbitrary number (I chose 1 - 8, you can choose anything that makes good sense) to replace the text section names for the vertical value axis of the bubble chart. If you feel a real need to show those text categories on the Y axis of the chart, you can use a technique like this to "create" a vertical category axis: https://peltiertech.com/Excel/Charts...egoryAxis.html

    With the data arranged like that, creating a bubble chart should be as easy as selecting those first three columns and inserting a bubble chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    12-08-2017
    Location
    Plymouth, UK
    MS-Off Ver
    15.4
    Posts
    2

    Re: Graph displaying the wrong information

    Thankyou that worked!

    To help anyone else who is stuck with this issue here is an image up of the process.

    \1

    I can't find a reliable place to host files for more than a month so send me a DM if you would like the source file.

+ 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. Help Formula displaying wrong value!
    By ExceLLemon in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-02-2015, 12:32 AM
  2. Graph data is on wrong reference point on graph.
    By NThompson7* in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-02-2015, 08:40 AM
  3. [SOLVED] VLOOKUP with MATCH... Displaying wrong column information
    By oneillgirl808 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2013, 09:14 PM
  4. Replies: 7
    Last Post: 06-21-2011, 03:24 AM
  5. Line graph displaying wrong values
    By Leia in forum Excel General
    Replies: 4
    Last Post: 04-20-2011, 08:20 AM
  6. Value displayed on graph is wrong- but graph is right?
    By Need Help 123 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-18-2006, 06:45 PM
  7. Cell displaying wrong figure
    By tcapewell in forum Excel General
    Replies: 1
    Last Post: 01-26-2005, 07:52 AM

Tags for this Thread

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