# Pareto Chart

Hello! Looks for help creating a pareto chart.

I have exported to Excel the column: Site - created a pivot to get the number of site visits - got a cumulative percentage and just copy/pasted without all the formulas - saved to desk top.

I have the bar chart set up with top 30 sites, Y Axis Descending but can’t figure out how to get the cumulative percentages in there.

Any help is appreciated! Let me know if additional details are needed.

Hey Jen! Charlotte here for the team! Happy to help out with this!

My apologies if you’ve already tried this but could you let me know if you’ve tried following the steps outlined in this guide?

Specifically the part outlined in steps 5:

Right-click on any of the blue bars in the chart and click Series when the dropdown menu appears, then select Cumulative Percentage .

When the menu pops up on the right, glance toward the bottom and choose the Right axis beneath the Axis dropdown.

Let me know how this goes!

Yes, I looked at that.

Step 1: gather your data. Based on the picture from step 2, I pulled out the columns “Name” and “Site Visits.”

Step 2: organize, which I did – same as above “Name” and “Site Visits.” Then sorted “Site Visits” from large to small.

Step 3: calculate the “Cumulative Percentage,” which I did.

Step 4: Highlight all data including titles. Then click “insert” in the bar at the top and select chart – combo chart. I looked in Monday and Excel for this option (since I don’t think it’s clear which you are supposed to be doing this in) but I don’t see Insert anywhere in either programs. Nor Combo chart as a default selection or Chart type dropdown under Setup.

Yes, I looked at that.

Step 1: gather your data. Based on the picture from step 2, I pulled out the columns “Name” and “Site Visits.”

Step 2: organize, which I did – same as above “Name” and “Site Visits.” Then sorted “Site Visits” from large to small.

Step 3: calculate the “Cumulative Percentage,” which I did.

Step 4: Highlight all data including titles. Then click “insert” in the bar at the top and select chart – combo chart. I looked in Monday and Excel for this option (since I don’t think it’s clear which you are supposed to be doing this in) but I don’t see Insert anywhere in either programs. Nor Combo chart as a default selection or Chart type dropdown under Setup.

I’m looking for a way to do this in monday too. have no problem creating this in sheets and excell. but we’re in need of displaying it on monday too, and the guide that was shared only describes doing it on 3rd party programs not through the charts provided in the dashboards?

1 Like