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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to make chart axis minimum a reference?
Unfortunately, no. This is an issue that's been raised repeatedly to
Microsoft (as well as several suggestion threads on this forum) but so far, no luck. The closest I can think of that might work would be to look at dynamic charts (quick Google search of "dynamic charts XL" or search around here), and somehow connect your Named Range to the TODAY() function to have it adjust. Not a perfect solution, and a lot depends on how your data/chart is setup. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Babymech" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Possible to make chart axis minimum a reference?
If you aren't averse to a little VBA programming, you can get this effect:
http://peltiertech.com/Excel/Charts/...nkToSheet.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Babymech" wrote in message ... 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? |
Reply |
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 |