![]() |
Multiple charts
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 |
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 |
All times are GMT +1. The time now is 08:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com