Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy/Paste custom Excel chart to Word/PowerPoint | Excel Discussion (Misc queries) | |||
How can I build a custom list in Excel | Excel Discussion (Misc queries) | |||
Copy Charts from Excel worksheet to PowerPoint | Excel Programming | |||
Macro to copy Excel charts to existing Powerpoint file | Excel Programming | |||
Help! How to add many excel charts into PowerPoint at once? | Charts and Charting in Excel |