Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi
I need to create multiple charts from one set of data, where each new column of data will need a new chart using the same categories from the first columns. Is there any quick way of producing multiple charts for this at the same time? Thanks |
#2
![]() |
|||
|
|||
![]()
Hi,
I think you can create your first chart, and set everything up how you like it. Then, copy the chart and paste it several times. Then, left click on some white space inside the plot area of each new chart, to select it, and scroll over to where your data is stored. The data source columns should be highlighted. You can just left-click-grab onto the edges of those columns and move them over to the next column that you want. And repeat. Hope this helps. "Jo Ball" wrote: Hi I need to create multiple charts from one set of data, where each new column of data will need a new chart using the same categories from the first columns. Is there any quick way of producing multiple charts for this at the same time? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Copy multiple charts from Excel to Power Point | Charts and Charting in Excel | |||
Print multiple excel charts within one sheet to fit to a page lik. | Excel Discussion (Misc queries) | |||
Multiple charts | Charts and Charting in Excel | |||
Macro for multiple charts | Excel Worksheet Functions |