I currently combine weekly data with daily data for an excel chart.

enter image description here enter image description here

How can I select my data so it is consistenly weekly? Or is there a chart feature to only include the weekly data? I don't want to manually pick dates either using the date picker chart feature.

  • 1
    For the weekly data, is it some sort of aggregate of the daily data, or do you just want a given day's data? – cybernetic.nomad Oct 11 '18 at 20:08
  • @cybernetic.nomad no aggegrate, just a given days. – excelguy Oct 11 '18 at 21:06
  • Try using a Pivot Chart, and then "Group" the date axis to your desired span. – PeterT Oct 11 '18 at 21:14
  • 1
    No please dont make me use a PIVOT CHART! PLEASE! I will if I have no other choice. – excelguy Oct 11 '18 at 21:20
  • As a work-around, just convert your data to a pivot table and reap the benefits of that. But, chart the data as a regular line or xy/scatter chart. If you create the chart first, then select the data through the dialog box, you won't have to worry about the pivot chart nonsense. – dav Oct 12 '18 at 12:38

Assuming the first column of data is in column A, make a helper column with the following formula in it:


and populate down

Autofilter on the day of the week you want to use for your data.

The chart should skip hidden rows

  • if I converted to a pivot , would it be easier? I'm trying to incorporate this stuff in vba. – excelguy Oct 11 '18 at 21:32

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.