You could also create a named range that refers to the non-contiguous ranges you want included in the chart. You could, within the chart, set the data range for the source data to this: Assume, for a moment, that your data was in A1:B15, and that there were weekends in rows 7, 8, 14, and 15. It may be better to base your chart on a non-contiguous data range. The drawback to this, of course, is that it creates two sets of data that may need to be updated or kept in sync in some way. You would still have your master data for whatever purposes you need, but you could base your chart on the modified copy of that data. One is to simply make a copy of your data (maybe copy the whole worksheet) and then delete the rows that contain weekend data. There are a couple of ways you could approach this problem.
In other words, she wants them displayed in the data table, but not in the chart. She knows that she could hide the rows and they would be excluded from the chart, but she still needs the hidden rows to be displayed in the table. The data includes weekends, but Pam doesn't want the weekend data included in the chart. The data was collected from information generated on her company's shop floor. Pam keeps a month's worth of data in a table and created a chart based on that data.
