Create charts on different sheets by clicking a button

{ 6 Comments }

Assume a five column database with the first column containing codes, second one containing a separator, third one containing some alpha values, fourth one is a combination of the first three columns and the last column has response times.

One may want to create as many charts as there are codes in column A.  The charts should get created on different sheets with the click of a button.

You may refer to my solution in this workbook.

Leave a Comment

Your email address will not be published.

*

  • Can the graphs be customized, i.e instead of the bars being in blue can we change the colour without going in each individual sheets. The colour could be same across sheets.