combined chart legend
 

I am using a chart to show our current performance in bars combined with
performance of other organisations as lines. Our perfomance is banded and I
have coloured each bar to show pefromance banding (ie 1 to 10% green 11 to
20% blue etc, however, on the legend I have only one element for all the
bars. Is there a way to create a legend for each bar banding, as well as
keeping the single element for the lines. Any help please.

combined chart legend
 

Hi,

You only have one legend entry for your bars because you only have 1
series. The legend will not reflect the formatting you have applied to
each bar.
To do that you need multiple bars. Have a look at Jon's page on
conditional charts.
http://peltiertech.com/Excel/Charts/...nalChart1.html

If you still wish to retain what ever method you are using currently to
format the bars you can. But to add legend entries you will need to add
extra data series, even if they have zero values.

Cheers
Andy

Jim.c wrote:
I am using a chart to show our current performance in bars combined with
performance of other organisations as lines. Our perfomance is banded and I
have coloured each bar to show pefromance banding (ie 1 to 10% green 11 to
20% blue etc, however, on the legend I have only one element for all the
bars. Is there a way to create a legend for each bar banding, as well as
keeping the single element for the lines. Any help please.

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info