Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating multiple bar charts
I have a large worksheet and have to create separate bar charts for all the
data in each row. I know i can use F11 as the shortcut, however, as I have a few hundred rows, is there a quicker way then selecting each row individually and using F11? Any urgent help would be much appreciated. Thank you. Louise |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating multiple bar charts
What you want to do would require a fairly sophisticated macro(s) to setp
through each set of data and generate a chart for each with the appropriate Title, etc. If you are up to that, you might start by recording one, or two macros to produce the first couple of charts, then note the differences between the macros, and copy and paste them to form new macros and edit them accordingly.......if you want to try, get started and post back with particulars, if you run in to trouble.......... Vaya con Dios, Chuck, CABGx3 "Louise" wrote: I have a large worksheet and have to create separate bar charts for all the data in each row. I know i can use F11 as the shortcut, however, as I have a few hundred rows, is there a quicker way then selecting each row individually and using F11? Any urgent help would be much appreciated. Thank you. Louise |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating multiple bar charts
Hi 'CLR'
Yeah, I thought it would involve a Macro but was hoping there was a way around it. I'll give it a shot and see how I go. Thanks. Louise "CLR" wrote: What you want to do would require a fairly sophisticated macro(s) to setp through each set of data and generate a chart for each with the appropriate Title, etc. If you are up to that, you might start by recording one, or two macros to produce the first couple of charts, then note the differences between the macros, and copy and paste them to form new macros and edit them accordingly.......if you want to try, get started and post back with particulars, if you run in to trouble.......... Vaya con Dios, Chuck, CABGx3 "Louise" wrote: I have a large worksheet and have to create separate bar charts for all the data in each row. I know i can use F11 as the shortcut, however, as I have a few hundred rows, is there a quicker way then selecting each row individually and using F11? Any urgent help would be much appreciated. Thank you. Louise |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
creating multiple bar charts
You're welcome...........thanks for the feedback, and be sure to post back if
you run in to trouble, or have more questions.......... Vaya con Dios, Chuck, CABGx3 "Louise" wrote: Hi 'CLR' Yeah, I thought it would involve a Macro but was hoping there was a way around it. I'll give it a shot and see how I go. Thanks. Louise "CLR" wrote: What you want to do would require a fairly sophisticated macro(s) to setp through each set of data and generate a chart for each with the appropriate Title, etc. If you are up to that, you might start by recording one, or two macros to produce the first couple of charts, then note the differences between the macros, and copy and paste them to form new macros and edit them accordingly.......if you want to try, get started and post back with particulars, if you run in to trouble.......... Vaya con Dios, Chuck, CABGx3 "Louise" wrote: I have a large worksheet and have to create separate bar charts for all the data in each row. I know i can use F11 as the shortcut, however, as I have a few hundred rows, is there a quicker way then selecting each row individually and using F11? Any urgent help would be much appreciated. Thank you. Louise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Multiple Charts from One PivotTable | Charts and Charting in Excel | |||
How do I place multiple charts in the same sheet? | Charts and Charting in Excel | |||
Is there a freeware application for creating gant charts in excel | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel | |||
Multiple charts in ChartSpace; problems with double Categories | Charts and Charting in Excel |