| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Chart Errors
I have created a chart using 100% stacked columns. I want my values to show
the % each value contributes to a total. I.E. Overage, Current Collections and Total Goal. The chart looks great; however, whenever I update my current collections, the percentage doesn't calculate correctly. The chart seems to be adding all values together to come up with the percentage need and the goal doesn't seem to shrink. Any ideas? |
|
#2
|
|||
|
|||
|
Are Overage, Current collections and Total Goal stacked on top of one
another. If so, the % calculated would be based on the total of all three. "Scaccia" wrote: I have created a chart using 100% stacked columns. I want my values to show the % each value contributes to a total. I.E. Overage, Current Collections and Total Goal. The chart looks great; however, whenever I update my current collections, the percentage doesn't calculate correctly. The chart seems to be adding all values together to come up with the percentage need and the goal doesn't seem to shrink. Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent Chart Assistance | Charts and Charting in Excel | |||
| Urgent Chart Questions | Excel Discussion (Misc queries) | |||
| Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
| Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel | |||
| pivot table multi line chart | Charts and Charting in Excel | |||
Hybrid Mode
