I’m sure it’s been asked before, but I was unable to locate the appropriate thread. I have sales data in Part/Qty/Month (yyyymm) displayed in a bar chart. Currently, when a part is selected, only those months having a quantity sold are displayed. I would like the entire timeframe displayed at all times. How do I lock the axis so that it displays all months?
It really depends on how your script is set up. If you are using a master calendar, it should be pretty simple, because you just have to remove the check on 'Suppress Zero values' and check 'Show all Value'. See attached for an example.
I got it to work using the "ValueList" method. However, because my data set consists of 36 months, the “=if(ValueList($(VarMonths…” statement required was pretty unwieldy. I’m a little surprised there isn’t a more straightforward solution. But thank you anyway.
It really depends on how your script is set up. If you are using a master calendar, it should be pretty simple, because you just have to remove the check on 'Suppress Zero values' and check 'Show all Value'. See attached for an example.
