Stacked Bar Chart - Two Vertical Axis Labels

**cjsec9** · 11-17-2008, 05:07 PM

I'm using a stacked bar chart to track the harvest time of various fruit trees in a Gantt style setup. The vertical axis has the names of the different fruit varieties, and the horizontal axis has 1-unit progression starting with the first day of harvest to the last day of harvest. What I'd like to do is on the right vertical axis, have the actual production quantity for each variety. Is this possible?

**Andy Pope** · 11-18-2008, 08:07 AM

Try adding another series to your existing chart
Move this series to the seconadry axis
Set the secondary axis labels to cells containing required values.

If you need more help post example workbook

**cjsec9** · 11-18-2008, 01:36 PM

I didn't quite get to the point of creating a secondary axis, but when I added the series into the Data Series dialog for the chart, I applied data labels and put No Fill for that series, so they show up right next to their respective bars, which is sufficient for the chart's purposes.

Thanks!