I've got combination chart that should be graphing 2 columns ( bars ).
The top row is the actuals and the bottom is the goal metric.
Example: Actual items quoted without Error was 98% Goal is 100%
The problem is that right now, it only graphs the bottom row ( showing the stagnate "100% goal bar" -all the way out from Jan to Dec ).
I thought that the other bar might just be invisible with a white color - but don't see that series graphing at all- when I hover across the chart -- looking for an invisible series to right click upon....
I've right clicked on it on every option, type, etc and even verified that the source was picking up all that it was supposed to -- and it is!
If I right click and check out SOURCE DATA ( Series Tab ) it shows both items in the Series block on the left with the actuals being the top item..
There's something limiting it -- keeping it from building a column ( bar) for both rows of metrics?
I work with tons of charts and have never had it "NOT" graph something that I've highlighted as source data...
This is making me nutso!
I appreciate any help you can provide!!
Thanks!
The top row is the actuals and the bottom is the goal metric.
Example: Actual items quoted without Error was 98% Goal is 100%
The problem is that right now, it only graphs the bottom row ( showing the stagnate "100% goal bar" -all the way out from Jan to Dec ).
I thought that the other bar might just be invisible with a white color - but don't see that series graphing at all- when I hover across the chart -- looking for an invisible series to right click upon....
I've right clicked on it on every option, type, etc and even verified that the source was picking up all that it was supposed to -- and it is!
If I right click and check out SOURCE DATA ( Series Tab ) it shows both items in the Series block on the left with the actuals being the top item..
There's something limiting it -- keeping it from building a column ( bar) for both rows of metrics?
I work with tons of charts and have never had it "NOT" graph something that I've highlighted as source data...
This is making me nutso!
I appreciate any help you can provide!!
Thanks!