Hi, hoping someone may be able to help or advise on the correct search term I should use to find out how to do the following. I have three simple column charts based on tables, all formatted in the same colour.
The horizontal axis labels are hidden on purpose.I would like to be able to pick out one column on each chart for the same axis label. Ideally from a cell value or dropdown that another used can edit. So all the columns would be dark blue except for the one axis label selected. I can do this manually (as I did in the examples below) but have 3 charts that would each need amending 29 times on a regular basis. Any suggestions much appreciated. I hope I have uploaded the charts correctly as the first time I've asked a chart related question.