Fix my Graph

%3CLINGO-SUB%20id%3D%22lingo-sub-2814808%22%20slang%3D%22en-US%22%3EFix%20my%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2814808%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20work%20on%20a%20graph%20that%20I%20am%20trying%20to%20clean%20up%20and%20make%20more%20pleasing%20to%20the%20eye.%20I've%20tried%20using%20a%20primary%20and%20secondary%20axis.%20Any%20ideas%3F%20Below%20is%20a%20sample%20of%20the%20data.%20I'd%20like%20to%20get%20the%20count%20and%20the%20percentage%20on%20the%20same%20graph.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22380%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22116%22%3ECategories%3C%2FTD%3E%3CTD%20width%3D%2266%22%3ECustomer%201%3C%2FTD%3E%3CTD%20width%3D%2266%22%3ECustomer%202%3C%2FTD%3E%3CTD%20width%3D%2266%22%3ECustomer%203%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2266%22%3ECustomer%204%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHL%3C%2FTD%3E%3CTD%3E45%3C%2FTD%3E%3CTD%3E100%3C%2FTD%3E%3CTD%3E99%3C%2FTD%3E%3CTD%3E175%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EIL%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELL%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EML%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E1%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3CTD%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ECategories%3C%2FTD%3E%3CTD%3ECustomer%201%3C%2FTD%3E%3CTD%3ECustomer%202%3C%2FTD%3E%3CTD%3ECustomer%203%26nbsp%3B%3C%2FTD%3E%3CTD%3ECustomer%204%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EHL%3C%2FTD%3E%3CTD%3E100%25%3C%2FTD%3E%3CTD%3E98.50%25%3C%2FTD%3E%3CTD%3E99%25%3C%2FTD%3E%3CTD%3E100%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EIL%3C%2FTD%3E%3CTD%3E0%25%3C%2FTD%3E%3CTD%3E0.75%25%3C%2FTD%3E%3CTD%3E0%25%3C%2FTD%3E%3CTD%3E0%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3ELL%3C%2FTD%3E%3CTD%3E0%25%3C%2FTD%3E%3CTD%3E0.75%25%3C%2FTD%3E%3CTD%3E0%25%3C%2FTD%3E%3CTD%3E0%25%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%3EML%3C%2FTD%3E%3CTD%3E0%25%3C%2FTD%3E%3CTD%3E0%25%3C%2FTD%3E%3CTD%3E1%25%3C%2FTD%3E%3CTD%3E0%25%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2814808%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2826746%22%20slang%3D%22en-US%22%3ERe%3A%20Fix%20my%20Graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2826746%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1176152%22%20target%3D%22_blank%22%3E%40MSMITH379%3C%2FA%3E%2C%26nbsp%3Btry%20the%20attached%20file%20with%20my%20idea.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22PedroWave_0-1633693558801.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F316183i6FDD79DD5987CC1A%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22PedroWave_0-1633693558801.png%22%20alt%3D%22PedroWave_0-1633693558801.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20label%20options%20for%20each%20series%2C%20select%20the%20range%20with%20the%20percentages%2C%20as%20in%20this%20image%3A%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Graph%20Option%20Cell%20Values.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F316187i985B5039549C07D2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Graph%20Option%20Cell%20Values.png%22%20alt%3D%22Graph%20Option%20Cell%20Values.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EPedro%20Wave%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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