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
_______