Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Category Labels in Radar chart | Charts and Charting in Excel | |||
Formatting Chart Category Labels | Charts and Charting in Excel | |||
Category Labels(X) axis on a chart: | Excel Worksheet Functions | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel | |||
Bar chart & Category (x) axis labels | Charts and Charting in Excel |