#1   Report Post  
Jo Ball
 
Posts: n/a
Default 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
  #2   Report Post  
Dixit Dominus
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
Copy multiple charts from Excel to Power Point Genef Charts and Charting in Excel 1 March 2nd 05 01:25 AM
Print multiple excel charts within one sheet to fit to a page lik. lal Excel Discussion (Misc queries) 1 February 18th 05 09:47 PM
Multiple charts YOOPER Mike Charts and Charting in Excel 2 December 13th 04 01:31 AM
Macro for multiple charts JS Excel Worksheet Functions 1 November 19th 04 03:44 AM


All times are GMT +1. The time now is 06:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"