Results 1 to 2 of 2

adding mean and standard deviation values to chart while having % values

Threaded View

  1. #1
    Registered User
    Join Date
    05-18-2017
    Location
    Sweden
    MS-Off Ver
    2013/2016
    Posts
    22

    Unhappy adding mean and standard deviation values to chart while having % values

    I am having a hard time figuring out how to visualise my mean and standard deviation
    in the chart I have.

    I want to have the mean and stdav visualised in the chart like in the example, however
    because the values are in percentages (I want to have percentages) the mean lines always
    end up at 20 % and I would like this to be changed so that the line goes where it would if the percentage values were normal number values instead.

    For example the red data/IT graph has correct values but the middle line (mean line) is
    above the 17,65 % bars and when I calculate the mean normally like in the left side the mean is 2,14..
    which means that the line should be much further down as the 17,65 % bars represent 3 votes.

    Maybe there is a simpler way to do this?

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. visualise mean and standard deviation values in chart/graph
    By doters in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-17-2017, 05:08 AM
  2. Calculating Standard Deviation using IF and ignoring N/A values
    By sroh in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-19-2015, 12:25 PM
  3. Replies: 0
    Last Post: 02-04-2013, 01:18 AM
  4. Replies: 1
    Last Post: 07-19-2011, 08:31 AM
  5. Standard Deviation forumula: More than 30 values?
    By Goalie35 in forum Excel General
    Replies: 3
    Last Post: 12-15-2009, 05:37 PM
  6. Individual Standard Deviation Values for Each Column
    By Maurice. in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-14-2009, 11:48 PM
  7. [SOLVED] simulate values for a given Mean and Standard deviation
    By Myl in forum Excel General
    Replies: 3
    Last Post: 04-05-2006, 12:30 PM

Tags for this Thread

Bookmarks

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