I have a chart with a column that totals up the individual columns. However, when I plot it on a bar graph, the vertical axis is always scaled with respect to the "Total" column and that greatly distorts and misrepresents the data.
A B C Total
Yes 10 27 50 87 : This chart will have a maximum value of ~87
No 20 18 7 45
A B C
Yes 10 27 50 : This chart will have a maximum value of ~50
No 20 18 7
How can I plot a bar graph scaled correctly? Thanks.
How do I find the maximum number in the 2D chart above?
The simplest thing would be to just get rid of the 'Total' column. Try piping your results through:
| fields - Total
before passing the search to your chart commands.
"Total" is done with addtotals after the chart command.