No data labels on Pareto Line of Pareto Chart

nfulcher

New Member
Joined
Jul 23, 2015
Messages
2
Excel in office 365 now has a dedicated Pareto chart which is quick and easy to use. However, there is no option to add data labels to the Pareto line to show the percentage values.

Am I missing something obvious here?
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,330
Office Version
  1. 365
Platform
  1. Windows
I don't see any way to add Data Labels to the cumulative percentage line.

The Pareto Line (as Excel calls it) does not seem to be a data series at all, but something internally calculated (like Trendlines). You'll just have to create the chart as a combo chart, which means you will need to create a column of data (i.e., a data series) that represents the cumulative percentage line. This I found on the information superhighway: https://www.wallstreetmojo.com/pareto-chart-in-excel/
 
Last edited:

Jon Peltier

MrExcel MVP
Joined
May 14, 2003
Messages
4,943
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
Microsoft introduced a handful of new chart types in Excel 2016 and later, including Pareto charts, Waterfall Charts, and a few others. It's nice to have these chart types native in Excel, but unfortunately these new charts are incomplete. You have less formatting features and options compared to regular charts, and VBA can't do much with them.

I wrote about Pareto Charts on my blog, and I've written software to create Pareto charts.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,472
Messages
5,596,354
Members
414,060
Latest member
hermanseck

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top