If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Custom charts - default formatting
Hi,
I am making a custom chart and hits the problem mentioned in the article from Peltier: http://peltiertech.com/Excel/ChartsH...stomTypes.html It says: "Another problem with a custom chart type, or any chart with customized formatting. If a chart element with custom formatting is removed from the chart, then added again, the custom formatting is lost, and the element takes on the default formatting for that element in the default chart." Is there a smart way to solve this problem? Could the best thing to do be some VBA-coding and to keep track on the change-event from the chart and then reapply the custom chart type? |
#2
|
|||
|
|||
What element of the chart is losing its formatting?
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ tomjohns wrote: Hi, I am making a custom chart and hits the problem mentioned in the article from Peltier: http://peltiertech.com/Excel/ChartsH...stomTypes.html It says: "Another problem with a custom chart type, or any chart with customized formatting. If a chart element with custom formatting is removed from the chart, then added again, the custom formatting is lost, and the element takes on the default formatting for that element in the default chart." Is there a smart way to solve this problem? Could the best thing to do be some VBA-coding and to keep track on the change-event from the chart and then reapply the custom chart type? |
#3
|
|||
|
|||
I don't know if it is the best way, but I have done it for complex charts
I set up a sheet with the name "record" and run macros similar to Sub tryin() For i = 1 To SeriesCollection.Count Sheets("record").Cells(i, 1) = CI(i) Next i End Sub Sub tryout() For i = 1 To SeriesCollection(i) SeriesCollection(i).ColorIndex = Sheets("record").Cells(i, 1) Next i End Sub needless to say these are not the full macro "tomjohns" wrote: Hi, I am making a custom chart and hits the problem mentioned in the article from Peltier: http://peltiertech.com/Excel/ChartsH...stomTypes.html It says: "Another problem with a custom chart type, or any chart with customized formatting. If a chart element with custom formatting is removed from the chart, then added again, the custom formatting is lost, and the element takes on the default formatting for that element in the default chart." Is there a smart way to solve this problem? Could the best thing to do be some VBA-coding and to keep track on the change-event from the chart and then reapply the custom chart type? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Default formatting | rmellison | Charts and Charting | 1 | September 16th, 2005 05:02 PM |
Custom Auto Filter default setting should be contains | dmc | Worksheet Functions | 0 | June 14th, 2005 07:54 AM |
How can I create a custom envelope size and set it as the default | Pedro | General Discussion | 1 | April 29th, 2005 08:05 AM |
How do I make Maintain Destination Formatting the default | Dan in Ottawa | Visio | 0 | November 15th, 2004 09:35 PM |
PivotChart formatting: macro for multiple unique charts | Jocelyn | Charts and Charting | 2 | January 20th, 2004 05:12 PM |