Graph data ranges not formatted evenly|Dashboards & Charts|Excel Forum|My Online Training Hub

Hello

I hope everyone is well.

I have created a scorecard for physicians.  I used Mynda's technique of having the data displayed in two columns - one column for the selected doctor where all other doctors have blanks and then in the other column, the other doctors have values where the selected doctor has a blank.  This way the selected doctor can have a different colour so they can see how they measure to the other physicians in their group.

I think I've made this more difficult for myself but the data source uses the rank feature (again as shown in the Dashboard course) so that I am able to have a graph showing each doctor's total days in sequential order from highest to lowest.  The selected doctor data shows up in the correct location in the descending order but their column doesn't have the same sized gap as the columns for the other doctors.  Not sure this is fixable but thought I'd ask.

Thanks.

Shelley