Dynamic Horizontal Axis Labels on Chart

dkubiak

Board Regular
Joined
May 17, 2004
Messages
137
Office Version
  1. 2013
Platform
  1. Windows
I built a data table that adjusts in size based on parameters selected (eg. select a department and it shows values only for that department). The number of rows changes. I also built a stacked bar graph that I want to display the data. Is there a way to get the horizontal axis to automatically only include the row if the row as a value? Right now the axis includes a blank spot.
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
if you can get a #N/A into the blank then it should model without
 
Upvote 0
As mole999 noticed a #N/A should do the trick. Depending on the setup of your chart, you might also be able to solve your problem by changing the setting of what to do with blank cells in your data selection. Also hiding the row should solve the issue.
 
Upvote 0

Forum statistics

Threads
1,213,487
Messages
6,113,941
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top