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?
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
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!
Sorry, double post because of some sort of lag issue.
Last edited by cjsec9; 11-18-2008 at 01:48 PM. Reason: Double Post
The reason for the second axis was so the axis was labelled.
If your happy using data labels then yes there is in need for additional axis
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks