Thread: Same Charts Different Months

Originally Posted by Soltisolti

I have 9 charts that take data from one worksheet, data comes in daily. The charts are monthy and have several data series, at the start of each month a new set of charts have to be started. Is there a quick way of telling the charts it should only collect data for Jan then the next set for Feb etc without manually having to set the data range for each series.

Thanks solti

Hi,

not sure that I understand what you are asking, you can by VB code / Macro update a Range for a chart with something like

.ChartObjects("Chart 1").Activate
ActiveChart.SetSourceData Source:=Sheets("Sheet1").Range("B4:C64"), PlotBy:=xlColumns

or you can set the data area to #N/A and set the chart to ignore unused cells.

Does this help?
---

Originally Posted by Soltisolti

I have dates in column A and various other data out to column AC.
So Jan charts data would be from Jan 1 (row10) - Jan 31 row 41
Feb data would be from row 42 (1st Feb) to row 70 28 Feb
Mar from row 71 etc etc
I can go in and change the ranges the charts look at for each month manually. Was wonder if you had a master chart for the year, tell it to only display only Feb data, save it as Feb data, then change it to display only March data, save it as March data, same for the rest of the year.

solti

hmmm, no, and with your data it wouldn't have the same rows/columns as you have used,, You can, as you say, setup a chart for each month, or you can setup a single chart with a Month selector, where you can select a month (by click-select or scroll across to increase the month). your Row range would then need to be listed for each month and could be used to set the Source Input data range (as shown above)

A similar idea is attached, but is scroll-variable rather than 'month-select', but he 'Month-Quarter-HalfYear-FullYear' (albeit vertical instead of your required horizontal) might show you what is possible with a 'pseudo-select' scroll bar.

Otherwise just copy your chart and Paste, and setup for the next month, either by macro or manually.

Let me know how you progress.
---

Originally Posted by Soltisolti

Bryan

Thanks for the replies. I like the selector/scroll idea will give that a whirl.

Thanks solti

Good to see, and thanks for the response.

---