| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Setting the minimum/maximum display range of a chart
I thought I posted this question yesterday, but can't find it today so I'll
repost and hope for the best. Basically I'm using a stacked bar chart as a GANTT schedule, and want to ensure that the minimum and maximum display ranges are set to something relevant... What I want to do then is, ideally, to enter =TODAY()-30 (for example) as the minimum range and =TODAY()+30 as the maximum, but obviously this doesn't work in a straightforward way... does anybody know of a workaround for this, so that I can set the minimum range as an equation, or a reference? All suggestions are appreciated - thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding maximum, minimum in a range consists both Positive and Negative numbers | Excel Worksheet Functions | |||
| How cani draw maximum and minimum lines in a chart in excel? | Charts and Charting in Excel | |||
| bar chart axes minimum & maximum | Charts and Charting in Excel | |||
| Maximum and Minimum Lines linking a chart | Charts and Charting in Excel | |||
| Automatic formatting of minimum/maximum value in a range. | Excel Discussion (Misc queries) | |||
Threaded Mode
