Specify scale of y-axis of Expense Barchart in terms of money units

Anton Kratz anton.kratz at gmail.com
Fri Jun 12 07:06:09 EDT 2015


On Fri, Jun 12, 2015 at 3:02 PM, Wm <wm+gnc at tarrcity.demon.co.uk> wrote:

> > I made several custom configurations of the Expense Barchart, which
show me
> > how much money I have spent each month in certain categories. The
reports
> > are almost exactly how I want them to be, the only problem is that they
are
> > difficult to compare, because the scale of the y-axis varies with the
> > maximum amount of money spent on a specific day.
> >
> > It is possible to adjust the absolute height of the y-axis in terms of
> > pixels under:
> >
> > Reports -> Income & Expense -> Expense Barchart
> >
> > Options -> Display -> Plot Height
> >
> > However, what I want to do is to specify the absolute scale of the
y-axis
> > in terms of currency. I.e. for each month, the y-axis should be f.e. 400
> > pixel high (easily doable) and max out out at, say, 20.000 Yen.
>
>
> Not the way you want.  However you say you are fairly new and may well
have missed
>
> Reports / Sample & Custom / Custom Multicolumn Report
>
> using this you can put two or more reports next to each other and adjust
the heights as you wish.
>
> gnc won't presume relative values so you'll have to make the y-axis for
Yen vs Euro vs USD
> more or less match up yourself but once you know about this a lot of
comparative reporting becomes available.

Thank you for your answer Wm, but I apparently did not clearly enough
describe what I want to do, though I tried. I want to adjust the scale
covered by the y-axis, not the height. I can adjust the height. By "scale"
I mean: the range of money that fits into that height.

I.e. for each report, I want the y-axis to always go from 0 Yen to
specified-amount-of-money, for example 20.000 Yen or any other amount. So
that I compare several reports, say for different months or different
weeks. I played around with the Custom Multicolumn Report and I don't see
how it helps in this context at all. The scale is still dictated by how
much money Ihave spent in a given time period. However I want to set it
myself.

The goal is, let's say when comparing two months, to see wether for a given
day a stacked bar in one chart is higher or not than in the other chart.
But if the scale is different, as it now necessarily is, it can not be
visually compared.

"Yen vs Euro vs USD": Sorry, I do not understand, I am not concerned with
currency conversion, I just wrote Yen because this is my currency... could
be any opther denomination.

My original question still stands - if anyone has advice I would be
thankful. Or if such a feature could be implemented, I think it would be
relatively straighforward and easy to do and could be useful for many users.

Anton


More information about the gnucash-user mailing list