Hi all,

What I would like to do is highlight some data (e.g. cells A5:K16 on XYZ tab which shows month across the top, territory down the side, and cash values in the data table), click a button and the data is copied to another tab and a line graph is automatically produced with month on the X axis and values on the Y axis with different lines for each territory. Unfortunately, when I simply do this by hand, the graph is never set up correctly, so territory is on the X axis. I can change this by switching rows/columns, but would want to do this automatically.

However, if I instead highlight A6:K22 on the “ABC” tab, I would like to click the same button and produce said graph for the new data.

This is so that a consumer can just highlight whatever data they want, click a button, and a graph is automatically produced for ease.

Anyone know how I would do this?