[Solved] Weekly vs quarterly data in Line chart

[legalnan]

My data in column a is weekly. But for some reason the related chart is based on the quarterly data. Can you please tell me how to get the chart to reflect the weekly data? I am attaching the file for your information.

[MrProgrammer]

Can you please tell me how to get the chart to reflect the weekly data?

Double-click the chart to edit it. Double-click the X-axis. In the Scale section of the axis dialog change the type from Automatic to Date. For a monthly scale uncheck the Automatic features for Resolution and for Major Interval. Set the resolution to Months and set the major interval to 1 month. You can try making the resolution a week, but that will make the dates on your X-axis very crowded and the chart may not be able support an interval that tiny. Your X-axis is about 200 mm long and you're putting 135 weeks of data on it. So to label each week, the label will be about 1½ mm wide. Even if you can convince Calc to cram them in there, your labels would be unreadable.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[legalnan]

I think I followed your instructions but this is what I got - it's every other month and a different type of line chart. I appreciate your help.

[MrProgrammer]

a different type of line chart

A seldom use line charts. Maybe you will need to set Resolution to days for this one, keeping the major interval at one month.

it's every other month

The fundamental problem is that you're trying to cram too much information onto the X-axis. Calc doesn't have enough room to create labels for each month with the settings you're using for the axis. 135 weeks is about 30 months. To show all of them on a 200 mm wide X-axis, each labeI only gets about 6 mm. In the Label section of the dialog try setting Orientation to 270 and use Overlap for Text Flow. Experiment with various settings. It's your chart. Press the Help button in the dialog to learn about what its settings do. You will find the following note there:

• Problems may arise in displaying labels if the size of your chart is too small.
  You can avoid this by either enlarging the view or decreasing the font size.

If this solved your problem please go to your first post use the Edit ☐ button and add [Solved] to the start of the Subject field. Select the green checkmark icon at the same time.

[legalnan]

Mr Programmer - changing the resolution to days solved both issues. Thanks so much!