Results 1 to 3 of 3

Thread: Color-Coded Bubble Chart Not Updating X Values

  1. #1
    Neophyte ehale's Avatar
    Join Date
    Jun 2019
    Posts
    2
    Articles
    0
    Excel Version
    unknown

    Color-Coded Bubble Chart Not Updating X Values



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I created a bubble chart that is color-coded for two types. Everything updates when I change the values except for the X-Axis. Even when I create the chart from the initial data set, the bubble chart doesn't even pull in the correct values (screen shot below). You can see from the screen shot below the bubble A should be pulling in 4 for the X-axis, but it's pulling in 1.

    Click image for larger version. 

Name:	screenshot 1.PNG 
Views:	38 
Size:	59.4 KB 
ID:	9192

    The bubble chart is pulling from a data table that has formulas- the formulas in that data table are connected to the table to the left. The first table in the screen shot above is pulling from the original list on a different tab.

    I've tried changing the original data and all the data from "general" to "text," but that did not work. I also tried changing the x-axis formatting to automatic rather than manually changing the bounds, which also did not work.

    When i create the table without the colors all the values update correctly, so it has to be something in the formulas, but I can't figure out what it is. Can someone help me?

  2. #2
    Neophyte ehale's Avatar
    Join Date
    Jun 2019
    Posts
    2
    Articles
    0
    Excel Version
    unknown
    Here are the screen shots of my formulas for the x-axis

    Click image for larger version. 

Name:	screenshot 3.PNG 
Views:	38 
Size:	40.0 KB 
ID:	9193

  3. #3
    Neophyte Dave Paradi's Avatar
    Join Date
    Jun 2019
    Location
    Mississauga, ON
    Posts
    1
    Articles
    0
    Excel Version
    365
    I don't think it is the formulas, but in how the data series are defined in the chart. Excel rarely can properly figure out how the data is structured when there are multiple series in a chart that requires an X and Y coordinate (this also happens with scatter plots). You can use the Select Data button on the Chart Design ribbon to open the Select Data dialog box. From there you can edit where Excel should look for each of the parameters it needs for the graph. Here is a screen shot of the settings for the second series in a bubble chart and you can see that by telling Excel where the X values are it correctly places the A bubble. Hope this helps.
    Click image for larger version. 

Name:	Color coded bubble chart.jpg 
Views:	35 
Size:	72.6 KB 
ID:	9206

Tags for this Thread

Posting Permissions

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