I have a sheet with data in the patern of this example.
example.xlsx
What I am doing to solve my problem is draw a line manually at the end of each week, but everytime I insert a new week of data all the columns are shifted and I have to move all the lines I drawn.
The options I have are or to make the chart size static so the columns dont get out of the place or to make the chart do some separation of the weeks (draw a line, separate by groups, anything that will help me identify the weeks).
Any tip?
Bookmarks