Attached file - tab chofatexpend...
Combo chart with stacked data & HR data.
Want/need X axis to ignore all NA data without user having to go in & edit the 'ranges' as to make the end output copy & paste viable for non-excel users. Am mostly interested in ignoring the NA's as to keep the graph visually simple as for a Physical Therapist to be explain it to a customer w/o extraneous data.
I've been perusing all the assorted links that I can find on how to get a bar chart to ignore the data but none of the links address the challenge when the #NA is in the x axis...
the #NA is based on if statements using na() to create the #n/a error which seems to be the first step every link indicates needs to be done to then be able to exclude the data.
Thanks in advance for your thoughts/assistance.
- gina
Bookmarks