Cycle Through Table

[Will03]

Hello... I have a table and chart in an excel sheet and would like to know what I can do to make the table and chart dynamically cycle through the data.


As you can see in the attached picture the table has a Monthly column as well as columns for 5 weeks of data. I would like the Chart to plot the new data I enter in this case for week 2 and then for all the weeks after and change as I enter the new information. More importantly I would like the Chart to begin plotting on the Week 1 column when I enter the new data there.

[protonLeah]

To attach a Workbook
(please do not post pictures or links to worksheets)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[noboffinme]

Hi Will03,

Not sure if you mean auto update the chart as you add data?

If so, here's a link;

http://www.extendoffice.com/document...ate-chart.html

[natefarm]

I think this will do what you want. I've set it up to initially use the data range of C3:G15 as in your example, but you can adjust as needed.

Please Login or Register  to view this content.