Chart shwoing daily dates when data is weekly

Hi,


I have some data that I need to add into a graph. The data is seperated by weeks but when I create the graph, it seperates the data by days. It then shows all of the data for the particular week in the first day of that week. Is there a setting to change the graph so that it shows weekly instead of daily data? I've added an attachment that explains this a little better.

Thanks

Originally Posted by oeldere

a3 = weeknumber(b3) and drag down.

after that a graph.

see the attached file.

Hi oeldere,

Thanks for your help but I was hoping that there would be solution by chanign one of the settings on the actual.

I've actually found a solution so for anyone else having this problem, if you right click on the bottom axis, click on format axis and select text axis under axis options, that should fixed it.