Hello, I am looking for a solution to my Problem. I have a table with 3 Columns. In Column A are dates that are the beginning of each week since 2020. In columns B and C are Data about Units Produced.
I am wanting to create a Clustered Column Chart that has the two Units Produced Numbers next to each other on each given date. However, given the number of dates, this gets unreadable pretty quickly.
I am wondering if there is any solution that would allow me to dynamically set which dates appear on the X Axis of the chart. If this were a Pivot Table, I would just add a timeline, but this does not appear to be a feature for charts. I can also define the beginning and end dates with formulas no problem, but I am not familiar enough with Charts to know how to set the formulas as the Min and Max values for the axis.
Thank you so much in advance for any insight into the problem!
Bookmarks