So I have a simple table... Month, Budget, Actual, Varaince Percent
I created a chart based on the same dataset with "Variance Percent" in the data field of the chart and no series and and "Month" as the category. It looks fine.
I removed the "Month" from the chart and drop in the table. I get bars with the correct numbers, (one bar for each month and the marker is displaying the Variance Percent corectly), but the bars aren't porportioned properly. 10% is same length as 50%. And I have a 45% that is longer than 25%. I thin the scale might be differnet for each bar.
Anyone know how to fix?