Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating custom chart legen pallettes/styles symbols
i need to produce 20 seperate charts based on different data, and i want the
series names and markers to be the same for each chart. question: best way to do this with a macro? create custom templates/palettes in excel? any feedback appreciated cheers, Mango |
#2
|
|||
|
|||
this is an interesting quesion...i would be interested if anyone can answer
"chartdummy"s question... trying to do something similar myself thanks, Me "ChartDummy" wrote: i need to produce 20 seperate charts based on different data, and i want the series names and markers to be the same for each chart. question: best way to do this with a macro? create custom templates/palettes in excel? any feedback appreciated cheers, Mango |
#3
|
|||
|
|||
Hi -
What I've done is to create a chart template and then programmatically replace cell references. First, plan this out: set up your data in rows in a worksheet called Data. Then create a chart range with a link to the first row of your data set. Make sure that your dates for the Xrange are directly above the data set. Create a chart via the usual methods and format it the way you want to. You can either save the chart in-sheet or as a separate chartsheet. In either case, you can then record a macro: select the series you want changed, change it and then end the macro. The code that you then have should provide you with enough info to provide the core of a loop to step through the data. You can save the individual charts on a separate sheet (call it "Charts") and then via CopyPicture you can keep the charts. I use this basic method to create around 4000 charts every month in around 6 hours. The code I have wouldn't make much sense to give you, since it has all sorts of hoops that I have to jump through in order to get the data into Excel, but the above method works great. Further, you can also label the shapes that you insert the pictures of the chart into in order to simply grab them from Word or PPoint, if you give them meaningful names (like "PresPage3B" instead of "Picture 385"). John |
#4
|
|||
|
|||
You could make a custom chart type to apply to the data:
http://peltiertech.com/Excel/ChartsH...stomTypes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ ChartDummy wrote: i need to produce 20 seperate charts based on different data, and i want the series names and markers to be the same for each chart. question: best way to do this with a macro? create custom templates/palettes in excel? any feedback appreciated cheers, Mango |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating custom list with a comma in it | Excel Discussion (Misc queries) | |||
Setting custom chart causes plot area to collapse | Charts and Charting in Excel | |||
creating an x,y chart | Charts and Charting in Excel | |||
Creating a dynamic chart | Charts and Charting in Excel | |||
Creating an x,y coordinate chart | Charts and Charting in Excel |