Results 1 to 6 of 6

Wrong Average and standard deviation values in chart group of 3.

Threaded View

doters Wrong Average and standard... 04-10-2018, 12:21 PM
JeteMc Re: Wrong Average and... 04-11-2018, 04:13 PM
doters Re: Wrong Average and... 04-12-2018, 11:04 AM
JeteMc Re: Wrong Average and... 04-12-2018, 02:40 PM
doters Re: Wrong Average and... 04-13-2018, 09:55 AM
JeteMc Re: Wrong Average and... 04-13-2018, 11:31 AM
  1. #1
    Registered User
    Join Date
    05-18-2017
    Location
    Sweden
    MS-Off Ver
    2013/2016
    Posts
    22

    Wrong Average and standard deviation values in chart group of 3.

    Hello again, I have figured out some of my graphs problems and it seems to me
    that the excel file graph im linking here now visualizes the average lines wrong/inverted from the value i seeks to show in the graphs.

    The png picture shows my "desired results" of the avg lines.
    In the attached excel file below the picture u can see my excel graph example which has the wrong avg lines.

    Calculating the avg myself gives the lines in the png which seem to show the correct avg on the graph,
    however in my excel file it seems that the avg lines are inverted somehow?
    For example the red graphs avg line in the excel file goes downwards when it should be more upwards.
    It displays the value wrong atleast or the visualization is very off and i can figure out how to fix it.

    I want percentages for normalization in the actual graphs so I can not just use the actual values only.
    I would appreaciate quick help with this one.
    Attached Images Attached Images
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Standard deviation - New average
    By passco in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-24-2017, 03:06 AM
  2. [SOLVED] adding mean and standard deviation values to chart while having % values
    By doters in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-19-2017, 05:09 PM
  3. 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
  4. Replies: 3
    Last Post: 07-15-2017, 12:29 PM
  5. SQL calculate Average and Standard Deviation and Group BY
    By anrichards22 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-09-2015, 05:49 AM
  6. Replies: 2
    Last Post: 08-23-2007, 03:07 AM

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