Prev: Crop excel charts
Next: change color of curve line as time changes
From: Lulu on 7 Dec 2009 14:54
I'm trying to add axis labels to a bar chart but can't seem to do it unless I
link my series together. If I do this then I can't put separate error bars
on each bar. This is driving me crazy and any help would be great. Thanks!!!

From: Luke M on 7 Dec 2009 16:05
One way would be to create custom labels. I believe the technique used here:

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

could be duplicated with your chart. In summary, you create a dummy series
that sits along the y-axis, have it display values (aka, your labels) and
then hide the real y-axis.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Lulu" wrote:

> I'm trying to add axis labels to a bar chart but can't seem to do it unless I
> link my series together. If I do this then I can't put separate error bars
> on each bar. This is driving me crazy and any help would be great. Thanks!!!
>
 | 
Pages: 1
Prev: Crop excel charts
Next: change color of curve line as time changes