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 %.
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 %.