Most valuable professional
  • Hot Topics

Excel Create Line chart by Week

Hi How can I create a Line Chart by Week for the following data: Date WTI Price US$ 01-09-2014 94.96 02-09-2014 92.88 03-09-2014 95.54 04-09-2014 91.45 05-09-2014 93.29 06-09-2014 93.29 07-09-2014 93.29 08-09-2014 92.66 09-09-2014 90.01 10-09-2014 90.20 11-09-2014 89.54 12-09-2014 90.25 13-09-2014 90.25 14-09-2014 90.25 ..... ..... 30-09-2014 91.50 The X-Axis Date type only allows Resolution by Date/Month/Year. We would like to view the chart by Weeks. We do NOT want to use the Days resolution where the major interval is 7.

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of November 19, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel