LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default Build custom charts in Excel and copy them to PowerPoint

Apologies in advance for the lengthy request. I have no idea if this is even
possible to do with a macro.

I have roughly 350 lines of data that I need to create charts from. Each
line will generate its own chart. I need cylinder charts that fit the
following criteria (all chart options set to default unless noted differently
below):

960 pixels (136.43 column width) wide X 578 pixels (34 cells @ 12.75 row
height) high
The Chart Title is in the A column
The B1 cell contains the x-axis label "Min"
The C1 cell contains the x-axis label "Median"
The D1 cell contains the x-axis label "Data"
The E1 cell contains the x-axis label "Max"
The "Min" Cylinder should be yellow
The "Median" Cylinder should be blue
The "Data" cylinder should be red
The "Max" cylinder should be black
Data labels should be present, above the appropriate cylinder, and should
show value
The Chart Area should have no border and no background
Gridlines should be Gray - 25%
The Floor Area should also be Gary - 25%

After all of this, the chart should be copied to its own slide in an open
PowerPoint Presentation, the chart should delete (because of Excel's built-in
number-of-chart limitations), and the process repeat until all 350 or so rows
have been charted.

Simple, right?

Since I know next to nothing about vb, macros, and the like, it would be
much appreciated if any responses could include which references to turn on,
etc. Also, since I'm guessing that a macro like this will take some time to
write, would anyone who decides to tackle this please let me know you are
doing so? I don't mind waiting in the least, but if this is too daunting of
a challenge, I'd like to know that no one is working on it so I can get to
work on building these charts manually. Many thanks. :)
 
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
Copy/Paste custom Excel chart to Word/PowerPoint Andy Excel Discussion (Misc queries) 0 September 1st 09 08:51 PM
How can I build a custom list in Excel T2Amy Excel Discussion (Misc queries) 2 October 15th 07 08:39 PM
Copy Charts from Excel worksheet to PowerPoint Koulla Excel Programming 3 October 30th 06 02:28 PM
Macro to copy Excel charts to existing Powerpoint file [email protected] Excel Programming 1 September 18th 06 08:32 PM
Help! How to add many excel charts into PowerPoint at once? Joules Charts and Charting in Excel 1 July 13th 06 06:58 PM


All times are GMT +1. The time now is 08:46 AM.

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"