Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple Bar Charts from 1 Worksheet
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Multiple Bar Charts from 1 Worksheet
On Jul 5, 12:43*am, Jeffrey Marks wrote:
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create multiple Charts from one worksheet | Charts and Charting in Excel | |||
Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
how to select multiple charts on a worksheet in excel 2007 | Charts and Charting in Excel | |||
Give multiple charts on a worksheet/workbook same header or footer | Excel Discussion (Misc queries) | |||
Give multiple charts on a worksheet/workbook same header or footer | Charts and Charting in Excel |