
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Pareto chart reference line
I am creating a Pareto chart with both a line chart(showing accumulation) and a bar chart (showing the numbers). I want to draw a straight line at 80%. How can I do that? Please find attached a screenshot
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See attached example. The reference line is added on the Presentation tab. Is that what you need?
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See attached example. The reference line is added on the Presentation tab. Is that what you need?
talk is cheap, supply exceeds demand

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a lot Gysbert. Thats exactly what I wanted.
Funny how one sometime misses a simple thing. I tried 80, 80% and many strings of that kind. None worked. I didnt try a simple 0.8

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Im looking for somtehin like thah, but instead of a line , i want a a new column wich the rows under the accum of the 80% be marked with a value of "A", and then the other 20 % with "B".
All this new values in a newcolumn in the same Straight, or Pivot chart, is it possible?
