Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: Exporting custom chart types

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Texas Instruments
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've created a custom chart type. I want other users to be able to use this custom type also. How do I place this custom chart type on other people's machines? I'm using VBA to generate the charts.

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why don't you apply the chart attributes using your VBA?

  3. #3
    New Member
    Join Date
    Feb 2002
    Location
    Texas Instruments
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Because they interact quite a bit with each other, and the order that you assign the attributes is also important. I tried the VBA route, but it turned out to be a frustrating experience. Too bad there isn't a utility that takes a chart and displays all of the attributes. I guess I can add two hidden worksheets containing the two custom chart types I use to my excel app., and then define the custom chart types from those:

    Application.AddChartAutoFormat Chart:=ActiveChart, Name:="Test", _
    Description:="Test Chart"


  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-08 15:08, rdionne wrote:
    Because they interact quite a bit with each other, and the order that you assign the attributes is also important. I tried the VBA route, but it turned out to be a frustrating experience. Too bad there isn't a utility that takes a chart and displays all of the attributes. I guess I can add two hidden worksheets containing the two custom chart types I use to my excel app., and then define the custom chart types from those:

    Application.AddChartAutoFormat Chart:=ActiveChart, Name:="Test", _
    Description:="Test Chart"

    Have you considered distributing a Book.xlt file containing the Custom Chart type and have 'em put it in their XLStart folder?

  5. #5
    New Member
    Join Date
    Feb 2002
    Location
    Texas Instruments
    Posts
    47
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hmmm that isn't a bad idea. How does one find out where their XLStart folder is. Is an .XLT file a template?

  6. #6
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    > How does one find out where their XLStart
    > folder is.

    Use the Windows Find Files or Folders... command

    > Is an .XLT file a template?

    Yes. See the Excel Help topic for....

    "Customize the defaults for a workbook or worksheet by using a template"


    BUT... the more I think about it the more I doubt that these defaults are stored in the worksheet. This begs the question, "Then where?" Which currently I don't have the answer to!!!

    [ This Message was edited by: Mark W. on 2002-05-08 16:19 ]

  7. #7
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    [bump]

  8. #8
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    YEESSS!!! See the Excel Help Index topic for...

    "Custom chart types"

    ...notice (in the fine print)...

    "If you have added your own custom chart types, they are in the file Xlusrgal.xls."


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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