jlschneider11
New Member
- Joined
- May 13, 2022
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
I am currently working to create a bubble chart, and whenever I select the data, only every other row is included in the chart data.
The following is my data source table.
After selecting the data, and reviewing the "Select Data Source" window, I see the following:
When I click "Switch Row/Column, 1/2 of the selected data disappears (below).
Is there a setting that I tripped somewhere that causes this to happen? I've looked at the Hidden & Empty Cells rules, and see nothing that would drive this, as the missing data contains values.
Much appreciated.
The following is my data source table.
After selecting the data, and reviewing the "Select Data Source" window, I see the following:
When I click "Switch Row/Column, 1/2 of the selected data disappears (below).
Is there a setting that I tripped somewhere that causes this to happen? I've looked at the Hidden & Empty Cells rules, and see nothing that would drive this, as the missing data contains values.
Much appreciated.