I am using Excel 2007 to create a dashboard to show historical data. My spreadsheet already has the working functionality of listbox that updates charts. My question is how can I add to the existing code to allow the option buttons change the data on each individual chart? If I can get an expert to show me on 1 chart I can take it from there. The issues is that there are many ways but I am looking for the best way since I will have 30 charts to update. The offset in executive rollup data col IX is what will need to be used to giive some assistance. Perhaps new columns labeling 1d, 1w, 1m, 3,m, and 6m
The option buttons will be 1d (not ready yet), 1 week, (meaning week4 and week5, basically the way that it is currently set up and the prvious week from that) 1 month, 3 months, 6 month, and 1 yr.
I am currently working with the main dashboard only (Summary dashbord) and the data that is being pulled from is called "Executive Rollup Data". I am starting to work with chart 115.
Thanks for your help!