PDA

View Full Version : Fill Remaining Chart Percentage



f2e4
06-02-2008, 09:07 AM
OK,

so i have a barchart:

Dates along x-axis
% along y-axis

Not all of the bars go up to 100%.

Is anyone aware of a way, if the bar does not equal 100%, to add a second series that would put another bar on top to bring it up to 100%

I thought that i could just have the values on the page but my table is a long list of names in one column and a long row of dates. For each date, there is a sumproduct calculation which produces a %.

Bob Phillips
06-02-2008, 09:37 AM
Why not just change the scale of the x-axis from 0 to 1?