Fix my Graph

Copper Contributor

I'm trying to work on a graph that I am trying to clean up and make more pleasing to the eye. I've tried using a primary and secondary axis. Any ideas? Below is a sample of the data. I'd like to get the count and the percentage on the same graph.

 

CategoriesCustomer 1Customer 2Customer 3 Customer 4
HL4510099175
IL0100
LL0100
ML0010
     
CategoriesCustomer 1Customer 2Customer 3 Customer 4
HL100%98.50%99%100%
IL0%0.75%0%0%
LL0%0.75%0%0%
ML0%0%1%0%
1 Reply

@MSMITH379, try the attached file with my idea.

 

PedroWave_0-1633693558801.png

 

In the label options for each series, select the range with the percentages, as in this image:

 

Graph Option Cell Values.png

Regards,

Pedro Wave