How to display pivot data in a chart for specific dates

    I want to show values to months on a chart. However I desire to show the last six weeks separately on the same chart. How could it be possible? Any help would be great.

    [SIZE=4]"I don’t pretend we have all the answers. But the questions are certainly worth thinking about."
    Sir Arthur C. Clarke    [/SIZE]

    In the Power Pivot window, select a table that contains dates. In the Design tab, click Mark as Date Table. In the dialog box, select a column that contains unique values, with no blank values. Click OK. To use advanced date filters Navigate to a PivotTable or PivotChart in the same workbook

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login