Hello,
I am fairly new to the world of Charts and I am trying to modify a Gantt chart to show custom labels. The labels I would like to show would be Q1-18, Q2-18, etc…. The attached model reflects data from other sources condensed into this format. I have been able to create the gantt chart but having issues labeling. I have tried to put the labels on the secondary axis, but I must be doing something incorrect. Is this something anyone has experience with? Thank you in advance.
Use the Select data to add new data series.
Move new series to secondary axis and change to line chart
Use select data again to specify the range for new series data and labels.
Add secondary horizontal axis to chart
format secondary vertical axis so it crosses at Automatic
You can delete secondary veritcal axis
It works! You provided my missing pieces to the puzzle. Thank you again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks