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?
Bookmarks