View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default 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!!!