Hello!
I have a set of code to generate at pivot chart based on the information entered by the user on a form. The data populates fine however if it is the first time that the dates are being viewed on the chart they are collapsed. I want these dates to open expanded showing the hours without having to highlight the day and select the Expand Field option for every date field.
I have been hunting for any code that relates on how to access this format on the chart but have not found anything that appears to work.
Can anyone provide a bit of direction?
Thanks
-JP
I have a set of code to generate at pivot chart based on the information entered by the user on a form. The data populates fine however if it is the first time that the dates are being viewed on the chart they are collapsed. I want these dates to open expanded showing the hours without having to highlight the day and select the Expand Field option for every date field.
I have been hunting for any code that relates on how to access this format on the chart but have not found anything that appears to work.
Can anyone provide a bit of direction?
Thanks
-JP
