If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Dynamic" Legends
I have a chart that has a series that simply illustrates the geometric mean
(as a flat line) spanning the seven days of a given month with the highest 7-day moving geometric mean. (So if the max 7-day geomean were on day 7, the series has the value of that geomean showing from day 1 through day 7... when a higher 7-day geomean pops up later, the line moves; so for example in november the series displayed as a line segment with the value of the geomean from days 19-25.) Since this data is meaningless until we have 7-days of data, I would like to have the line segment in the legend hidden; I've already taken care of the legend wording to be a blank string if there's no data, but I still have a fat brown line just sort of floating at the bottom of that chart. All other series legends have been eliminated, this it the only one I want to show and I only want it when it refers to valid data. So I'd like to find a way to have the legend disapper early in the month. I have a command button ("Set Up") that the users click to prepare the report for a new shift's entries. I'm wondering if I can add some VBA to that. Peace EQC |
Thread Tools | |
Display Modes | |
|
|