Register
Log In
Unanswered
Home
Excel Customer Service
April 18, 2015
Offline
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
See Answer
July 16, 2010
Offline
Hi Shelley,
Great to see you're using the techniques.
Are you able to share the file, or at least a screenshot. I'm trying to picture the gap issue as the gap should be the same. Perhaps it's the overlap that's not right. Is overlap set to 100%?
Mynda
Answers Post
Most Users Ever Online: 57
Currently Online:
16 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
