+ Reply to Thread
Results 1 to 2 of 2

Adding average values to bar chart

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    I bought it in 2018

    Adding average values to bar chart

    Hi guys,
    I have a bar chart for a group of items. The bars show the minimum and maximum numbers for items. I would like to add markers to all bars to show the average values as well, but I cannot do it.
    Can anyone help me please?

    I have attached the example file.
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    East Sussex, UK
    MS-Off Ver
    2016 primarily

    Re: Adding average values to bar chart

    You could do something like this where the averages are plotted as an XY scatter series (the numbers in the first column are to get the markers to line up with the bar chart categories), with no markers and a Y error bar to make a line for the average?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] taking the average without adding the Max and Min values
    By pboost1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-28-2018, 11:54 AM
  2. [SOLVED] Adding Calculated Average Line to Chart
    By Ivybananas in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-05-2017, 02:35 PM
  3. [SOLVED] adding an average line to Stacked Area in 3-D chart
    By fight2 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-11-2015, 01:52 PM
  4. Adding Moving Average on Top of Candlestick chart on excel 2010
    By vb765 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-01-2013, 03:57 PM
  5. [SOLVED] Adding an Average on Pivot Table Data Chart
    By greggatz in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 11-27-2012, 11:24 AM
  6. [SOLVED] Adding an average line to a bar chart
    By tylercoats in forum Excel General
    Replies: 2
    Last Post: 02-15-2006, 10:45 AM
  7. [SOLVED] How do I create a rolling average chart, adding most recent data?
    By Doug@NxEdge in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-04-2005, 10:30 PM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1