chart filtering

I have a pivot chart that displays the last 3 months of data onto a bar graph (eg, Since it is currently October, the graph shows Jul-Sep data). Instead of selecting the desired months manually , I would like to create a macro that will show the desired months every time the calender month...

I have an excel 10 spreadsheet that I add data to 5 days a week. I use the 30 last data points to create a chart. Currently I have to change all points on the chart every time I add to keep a rolling 30 day chart. Is there a way to set up a filter or some other means to automatically use the...

Table 1 Looks like mine table. (but mines actually 34 rows long including the header) TABLE1 <TABLE style="WIDTH: 343pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=457><COLGROUP><COL style="WIDTH: 118pt; mso-width-source: userset; mso-width-alt: 6698" width=157><COL...

I want to plot data over a series of dates, but wish to exclude weekend data. I add a column to the series called "day", use the WEEKDAY function to determine the day of the week, and use a filter to select only workdays. However, the chart still plots data for all the dates, and ignores the...