How do I add category labels in a chart but keep series separate?
 

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!!!

How do I add category labels in a chart but keep series separate?
 

One way would be to create custom labels. I believe the technique used he

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!!!