Hi,
I have two series going into my line graph. One is for christmas stock(L5:L48) and the other is for chocolate/ candy (I5:I48). . I have another column that contains the distribution dates required for a period of time (H5:H48).
What I'm trying to do is have the two data series represented on the line graph with two horizontal axes. The first axes would show the dates listed in the distribution date column (H5:H48). The problem I'm having is the horizontal axes is only displaying one date (one cell) even though I have selected a range of multiple dates.
Thank you for taking the time to read this post, all help is appreciated.
I have two series going into my line graph. One is for christmas stock(L5:L48) and the other is for chocolate/ candy (I5:I48). . I have another column that contains the distribution dates required for a period of time (H5:H48).
What I'm trying to do is have the two data series represented on the line graph with two horizontal axes. The first axes would show the dates listed in the distribution date column (H5:H48). The problem I'm having is the horizontal axes is only displaying one date (one cell) even though I have selected a range of multiple dates.
Thank you for taking the time to read this post, all help is appreciated.
