Hi everyone!
You have given me incredible solutions to my previous question, and I hope you can once again help me out here!
1. I want to create a chart that looks like the attached PDF file. I used scatter charts, and added labels as text boxes for the x-axis. So far, so good.
2. I have differentiated the data points (colour, shape, outline) based on performance, functional and leadership ratings, and added + or - to show change from the previous year.
3. I changed the data points one by one to get them the way I wanted, but now I have to do it for hundreds of data points.
Q1. Is there any way to set automatic (or dynamic) chart settings where the data points will get formatted depending on the data used?
Q2. Alternatively, is it possible to use formulas to change data points?
Thank you!
SDV
You have given me incredible solutions to my previous question, and I hope you can once again help me out here!
1. I want to create a chart that looks like the attached PDF file. I used scatter charts, and added labels as text boxes for the x-axis. So far, so good.
2. I have differentiated the data points (colour, shape, outline) based on performance, functional and leadership ratings, and added + or - to show change from the previous year.
3. I changed the data points one by one to get them the way I wanted, but now I have to do it for hundreds of data points.
Q1. Is there any way to set automatic (or dynamic) chart settings where the data points will get formatted depending on the data used?
Q2. Alternatively, is it possible to use formulas to change data points?
Thank you!
SDV