I have in cells A1 -A12 words (eg wages, electricity etc)
In cells D1-D12 I have values (numbers)
I am trying to get a bar chart where the number is displayed by the vertical
bar and at the bottom of each bar it gives the name (eg electricity,wages
etc)
I can get the bar chart using the chart wizard with the values ok but not
with the title for each bar.
Any help would be good
thanks
Andy Pope - 11 Apr 2008 19:38 GMT
Hi,
Select the range A1:A12 hold the CTRL key and select D1:D12.
Now use the wizard to create column chart.
Cheers
Andy
> I have in cells A1 -A12 words (eg wages, electricity etc)
>
[quoted text clipped - 10 lines]
>
> thanks

Signature
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
S - 11 Apr 2008 20:12 GMT
Thanks Andy, now sorted.
> Hi,
>
[quoted text clipped - 18 lines]
>>
>> thanks