+ Reply to Thread
Results 1 to 3 of 3

Custom charts - default formatting

  1. #1
    tomjohns
    Guest

    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. #2
    Jon Peltier
    Guest

    Re: Custom charts - default formatting

    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. #3
    bj
    Guest

    RE: Custom charts - default formatting

    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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1