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

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,118,755
Messages
5,574,048
Members
412,565
Latest member
roberttaekim
Top