creating charts in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2700450%22%20slang%3D%22en-US%22%3Ecreating%20charts%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2700450%22%20slang%3D%22en-US%22%3E%3CP%3Ei%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22IMG_0259.JPG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306803i84EF71C936041600%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22IMG_0259.JPG%22%20alt%3D%22IMG_0259.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20prepare%20a%20graph%20like%20this%20in%20excel%3F%3C%2FP%3E%3CP%3EPlease%20help%3C%2FP%3E%3CP%3E%3CIMG%20border%3D%220%22%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2700450%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2700491%22%20slang%3D%22en-US%22%3ERe%3A%20creating%20charts%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2700491%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1141777%22%20target%3D%22_blank%22%3E%40mehmet_almacioglu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20chart%20has%204%20value%20axes.%20A%20chart%20in%20Excel%20can%20have%20only%202%20value%20axes%2C%20so%20it%20would%20be%20difficult%20to%20plot%20all%20four%20series%20in%20one%20chart%20and%20keep%20it%20readable%20because%20the%20scales%20are%20so%20different.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

iIMG_0259.JPG

Is it possible to prepare a graph like this in excel?

Please help

3 Replies

@mehmet_almacioglu 

That chart has 4 value axes. A chart in Excel can have only 2 value axes, so it would be difficult to plot all four series in one chart and keep it readable because the scales are so different.

@Hans Vogelaar 

Thank you for your answer. I know it's a bit complicated but the professor asked me to do it So i have to try it another platform maybe in SPSS

Hi @mehmet_almacioglu 

 

Hope you are doing well. From your image looks that you have 4 measures/axis want to show on vertical or y axes and 1 dimension on x axis. I share with you an image as per your requirement.

 

Please select "Vertical Axis Line Chart" you can draw 1 up to 10 Y axes. 4 showing in this image.

 

You can check here for Microsoft Excel & Office 365. Image attached get from this add-in.

 

And if you are comfortable with Google Sheets, you can find here.

 

Thank You! 

 

Qaiser_j_0-1630680378264.png