I have a stack chart with three data points (15 deficiencies, 216 audited and the total of 630). When you add 15 & 216 the graph should be over 30% since the total is 630 but it is coming up short. Can you help me see what I'm doing wrong? I can't seem to attach the file. Hopefully you'll have some suggestions.
This is my only guess:
15 + 216 + 630 = 861
(15 + 216) / 861 = 26.8%
If you have the "total" as an input to the chart, it might be treating it as one of the variables to stack up, rather than an output.
But that's a blind guess on my part.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
To attach a sample workbook click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
BSB
I figured it out. It was adding 630 into the total making 100% 861 rather than 630.
Thanks for your time.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks