Excel should allow chart axes to be set from sheet data.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I often chart account balances where I have x axis of dates and y axis of
monetary amounts. It would be helpful if there was a facility to allow the x
axis minimum and maximum to be set to some value as calculated from the data
itself (or even calculated using a formula). I like to keep a "rolling"
picture of the last three months (so, today()-90 to today()) and the next
three months (today() to today() + 90) (on two separate charts). I have to
manually update the x axis's minimum and maximum each day.
 
you can set up formulas in cells to calculated your desired max/mins an
then have a macro call them into your charts - i have done this exac
thing at work
 
Back
Top