3

I'm attempting to make a 4 quadrant bubble chart in Excel to compare some competitor companies. I've input all my data from a pivot table, with 4 slicers to filter what the bubble chart is showing you.

Example

I have set the max value on the y-axis to 2100, with the x-axis crossing it at its midpoint. Unfortunately, when I change the filters, the y-axis needs to change as well, but I'm unsure how to get my y axis crossing point to change to the midpoint of the new value.

Example 2

Any help would be greatly appreciated.

Improve this question
3
  • 1
    You probably can't do this with built-in axis, but could create an "artificial axis" made from calculated points that adjust with your sliced data.
    – dav
    Commented Feb 15, 2018 at 13:26
  • Is there any value more than 2100 you have set for the Scale ?
    – Rajesh Sinha
    Commented Feb 16, 2018 at 11:26
  • No, 2100 is my max value
    – user402253
    Commented Feb 20, 2018 at 11:03

0

Reset to default

You must log in to answer this question.

Browse other questions tagged .