Hello,
I have a ton of charts that I need to update for the new year (the charts are not mine or my design, I'm just trying to help make someones life easier).
Each chart has to be updated to a specific month. I have a new chart for each month. For example, Chart1 displays data for January, Chart2 displays data for February, and so on...
Below is a picture of what the data looks like and what I need the code to select (see picture).
Also to clarify for simplicity, basically any range selected for the "Horizontal (Category) Axis Labels" the rest of the "Legend Entries (Series)" will be the same range one column over.
For example if "Horizontal (Category) Axis Labels" is Q431:Q461, then "3rd Shift" is R431:R461, "1st Shift" is S431:S461, "2nd Shift" is T431:T461, and "Target" is U431:U461.
I know I'm asking a lot but I don't have the slightest clue on how to put this code together. I greatly appreciate anyone will to take a look at this for me!
Data Selector.jpg
Bookmarks