a) In our example, in the chart options we had fixed the Chart axis as : Min 0 and Max 1. You first need to change the Max Value of Axis in the Chart options. For Example make the Max value as 2. This will make your axis maximum value as 200%. You can enter any value as the maximum %. Ensure that you keep a value greater than the Max% shown in the dataset.(example in our dataset 100% is the max value so I have taken 2 [ that is 200%] in the chart options. b) Next in the chart, put the Sales Series on the secondary axis. c) Then adjust the Gap Width of Sales Series to about 250%
Excelente recurso para gráficos en Excel.
Thank you for the beautiful chart video.
❤❤❤ Amazing
very informative . How can you please show the green as well as the Grey when actual exceeds the Target (Green bar is greater than the Grey Bar)
a) In our example, in the chart options we had fixed the Chart axis as : Min 0 and Max 1.
You first need to change the Max Value of Axis in the Chart options. For Example make the Max value as 2. This will make your axis maximum value as 200%.
You can enter any value as the maximum %.
Ensure that you keep a value greater than the Max% shown in the dataset.(example in our dataset 100% is the max value so I have taken 2 [ that is 200%] in the chart options.
b) Next in the chart, put the Sales Series on the secondary axis.
c) Then adjust the Gap Width of Sales Series to about 250%