I need to provide a quad-week and single week 'look' option in the same chart. If I choose a date axis I can get the weeks to expand and contract showing what I need (for the most part). But I loose some of the chart aesthetics which is not ideal because this applies to 4 of 8 'group' charts.
My Ask:
Can someone help me create a dynamic 'text' axis that will not chart cells with the #N/A value. And perhaps better stated, if the date is #N/A (resulting from formula), ignore those cells.
Any help appreciated!
Rhonda502
Bookmarks