Multiple Bar Charts from 1 Worksheet


J

Jeffrey Marks

I have a worksheet where the columns are the years and the rows represent a percentage by school district and content area (e.g. Math, reading, etc.)

I want to have 1 bar chart per row, showing each year as a separate bar. I can easily do this for 1 row at a time; however, the worksheet has 189 rows in it.

In reading some of the other posts here, I think this can be done, and it uses VBA code, but I'm not sure of what that code would look like. Any help would be appreciated.

Thanks

Jeff
 
Ad

Advertisements

X

Xt

I have a worksheet where the columns are the years and the rows representa percentage by school district and content area (e.g. Math, reading, etc.)

I want to have 1 bar chart per row, showing each year as a separate bar. I can easily do this for 1 row at a time; however, the worksheet has 189 rows in it.

In reading some of the other posts here, I think this can be done, and ituses VBA code, but I'm not sure of what that code would look like. Any help would be appreciated.

Thanks

Jeff

Do you actually want different 189 charts on your worksheet or would
you be happy with one chart which can show the data for any particular
row where you could use a spin button or scroll bar to choose the row?
xt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top