Quick Question: Chart Scale

[wyang6]

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.

[wyang6]

How do I find the maximum number in the 2D chart above?

[southeringtonp]

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.

[wyang6]

"Total" is done with addtotals after the chart command.