Forum Discussion
Solved
Advance Excel Graph Goal Line
So I have a graph that my bosses want the days next to each other in order over a select time period, which I did. Week1-Mon, Week2-Mon, Week3-Mon | Week1-Tue, Week2-Tue, Week3-Tue | etc But...
erictribble Not as colourful as yours but easier to maintain I believe. See attached.
Riny_van_Eekelen
So you in a sense, you added the weekday name and target (goal) to the data table, then pivoted the data table, then graphed the pivot table.
Freaking genius, I overcomplicated the hell out of it lol.
Quick side question though, how can I keep the week day names in order in the graph?
erictribble Because the day names are in fact real dates, Excel will by default sort the in ascending order (Mon through Sun). I assumed you wanted the graph to show Thu through Wed, so I just manually moved the days around in the pivot table and then chart followed.
If you want the charts to be in weekday order just sort the labels in ascending order.