Gantt Chart - Markers

Honeyeater

New Member
Joined
Aug 4, 2020
Messages
2
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
Hi everyone. I've made a Gantt chart that requires markers on each bar for a mean. I have manually placed markers there, but does anyone know if there is a way to include a marker in the data itself? Every time I update the data, the chart changes and the markers don't as they are just pictures. I have tried everything I can think of but cannot get it to work. The closest I could get was to have the mean numbers on a secondary Y axis, but this did not work either as the values are in the x axis. This is probably not the correct use of a Gantt chart, but it represents the data better than any other type of chart. Any advice would be greatly appreciated.

Gantt Markers.PNG
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Watch MrExcel Video

Forum statistics

Threads
1,109,277
Messages
5,527,736
Members
409,786
Latest member
AbdulMoix

This Week's Hot Topics

Top