| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to make chart axis minimum a reference?
I'm setting up a bar chart to function as a GANTT schedule in excel, and I'm
meeting limited success. One key issue that I would like to solve is adjusting the scope of the chart so that it only shows, for example, the current month and coming two months. I can do this manually - by adjusting the minimum of the chart to 39884 (today's date) and the maximum to 39974 I get a good overview of the coming weeks. What I'd really like, however, is the ability to make this link dynamic - to set the minimum to =TODAY()-10, for example, so that there's no need to make adjustments every month. This isn't easy to do, obviously, but is it possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a chart with 4 bars on one axis/1 line on 2nd axis? | Charts and Charting in Excel | |||
| make chart with both horizontal-x axis vertical-y axis | Charts and Charting in Excel | |||
| Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
| Minimum and maximum value of Axis set by user by reference to form | Charts and Charting in Excel | |||
| How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
Threaded Mode
