I am trying to create a combination chart in Excel - lines and bars.
nothing complicated. however, "apply to selection" button in chart
menu is disabled. how do I activate it? without it, I get the same
chart type for all the data. would really appreciate if anyone can
point a solution or, maybe, another way to create a combination
chart.
thank you, Gauhar
CyberTaz - 05 Aug 2007 19:45 GMT
In order to do what you are attempting you must first *select* one or more
data series in an existing chart. Otherwise the feature thinks you *do* want
to convert the entire chart.
Create your Bar or Line chart first. Then click a bar or line (shift+click
additional ones) then go to Chart> Chart Type, select the type & subtype you
want for the selected series.
Regards |:>)
Bob Jones
[MVP] Office:Mac
On 8/5/07 2:05 PM, in article
1186337123.605915.184620@x40g2000prg.googlegroups.com,
> I am trying to create a combination chart in Excel - lines and bars.
> nothing complicated. however, "apply to selection" button in chart
[quoted text clipped - 3 lines]
> chart.
> thank you, Gauhar