If the other users know nothing of custom charts, it's probably okay. If
not, you'll annoy anyone whose custom charts have been obliterated.

Here is a programmatic technique to distribute custom chart types to other
users:

http://groups.google.com/group/micro...0f8a219326de1a

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Hari" wrote in message
ps.com...

Jon Peltier wrote:
You can give them your user gallery file, at the risk of overwriting
their
own custom charts. The best thing is to sent them a regular workbook with
your chart in it, and showing them how to add it as a custom type.

Thanks for the suggestion. I was thinking that if I have a critical
number of charts as user-defined (some of my colleagues do quite a bit
of charting) probably it would be more easier to use this file (I now
see it as "XLUSRGAL.XLS") rather than adding in new workstations.

regards,
HP
India

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Hari" wrote in message
ups.com...

Jon Peltier wrote:
"Hari" wrote in message
oups.com...

Jon Peltier wrote:
You can create your own combination chart types very easily. Make a
line
chart with all of your data, select the Sales series in the chart,
go
to
Chart menu Chart Type, and select the Clustered Column type.


Thanks a lot for your response. I chose the sales series and did
right
click -- Chart type. There are 2 tabs Standard Types and Custom
types.
In both I see lots of varieties of charts but there is no "Clustered
Column" variety in it. I also tried choosing the "User-Defined"
radio
button within Chart Type but it is displaying only the "default"
which
is fully column type for all series.

You're looking too hard. On the Standard Types tab, select Column in
the
list of chart types (left side of dialog), and choose the chart
subtype
Clustered Column (top left choice in right side of dialog, the default
anyway).


Thanks for the pointer. Iam able to get it working right now. I have a
follow-up question. I have added this chart (Clustered column with rest
2 series as lines) as one of my user-defined charts so that in future
if I want I can quickl select it.

I would like to share this setting with other colleague(s) in an easy
manner. Is there any particular setting file I need to copy from my
computer and paste it in to a new one for it to automatically appear as
a user-defined chart?

Also, I see something strange. When I select any chart series it
selects alternate points starting from the first point in the
series. I
undertsand that even when it selects aternate points it actually
selects the whole of the series, but why has MS designed it to not
select all points

As the series gets more and more points, the selection indicators
display
a
smaller percentage of the selected points. I think this is for
legibility.
You'll get used to it.


Thanks this makes sense
regards,
HP
India

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______