Home |
Search |
Today's Posts |
#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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom formatting to force a decimal place | Excel Discussion (Misc queries) | |||
Custom Auto Filter default setting should be contains | Excel Worksheet Functions | |||
custom formatting ???/???? | Excel Discussion (Misc queries) | |||
How to revert back to default color palatte from custom | Excel Discussion (Misc queries) | |||
Custom Type Charts Problem | Excel Worksheet Functions |