I have the some data that has several points that begin on a Monday and end on a Sunday. I couldn't figure out a new column to create each Monday as a start so I just created a table in Excel to count all the data from Monday to Sunday of each week. As cyou can see, the data point holds the starting day for the week, but the x axis is starting with Sunday. How do I fix that. For the other image, the Months work, but the data points show for the first of each month. I don't want that. Thanks for any help.
Actually, my end goal just changed. I am attaching
a workbook. The vendor names have all been changed as were invoice numbers and stuff. In the first sheet, you'll see where I have two tables to calculate some data. Then the charts off to the side of them. Those charts are what I'm trying to recreate. I've got some other visuals to create now as well so they all need to key off the site. What I was trying to initally do is just create the charts based on the small table. The weeks would start on Monday's. So in the chart image I posted, if you put the cursor over a data point, it reveals the date, but it doesn't correspond with the axis information as it starts on every Sunday. Same with the year. But, now that I need to attach location, I'll have to somehow get the total tickets belonging to each contractor on both sheets, and then put it into that chart.