Re: Format a chart to automatically update with last 26 data points?

See
Dynamic Charts
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html
specifically example 2.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <283CF7FE-483B-44C3-AF28-FA4D6782F1BA@xxxxxxxxxxxxx>,
laf2day@xxxxxxxxxxxxxxxxxxxxxxxxx says...
> I am trying to make a chart that will pull the most recent 26 weeks of data
> automatically so I won't have to go in and change the range every single
> week. I am adding the newest data to the right of the the existing data and
> would like to have the chart just to the right of the most recent data.
>
> If you have any suggestions please let me know.
>
> Thanks!
>
> David
>
.

Relevant Pages

  • Re: Stop the line
    ... > in the data to chart. ... > exhibit the same problem as when it was focused on the original row. ... >> Custom MS Office productivity solutions ...
    (microsoft.public.excel.charting)
  • Re: Multi-Pie/Bubble Charting
    ... marker. ... Apparently you can't paste a dynamic pie-chart as the custom ... pie-splits can occur automagically to where updating the bubble sizes occurs ... > custom chart marker, if you copy the graphic, select the series, and paste ...
    (microsoft.public.excel.charting)
  • Re: Multi-Pie/Bubble Charting
    ... AFAIK there is no way to really make the plot area equal to the ... So, if you set the chart and plot areas to none, then copy picture + ... smaller* that the actual bubble. ... Custom MS Office productivity solutions ...
    (microsoft.public.excel.charting)
  • Re: Lines in chart when no data is present
    ... Jon Peltier, Microsoft Excel MVP ... Tutorials and Custom Solutions ... Chart Tab and set the Plot Empty Cells option. ...
    (microsoft.public.excel.charting)
  • Re: Pivot Chart Y Axis
    ... Pivot charts lose all customization when the table is pivoted. ... Or you could make a regular chart of the pivot data, ... Jon Peltier, Microsoft Excel MVP ... Tutorials and Custom Solutions ...
    (microsoft.public.excel.charting)