+ Reply to Thread
Results 1 to 7 of 7

How to fix this graphic

  1. #1
    Registered User
    Join Date
    03-22-2017
    Location
    Latvia
    MS-Off Ver
    Windows 10
    Posts
    3

    How to fix this graphic

    Hai!
    The problem is that I have a number of x values and it's expands graphic. So maybe there is opportunity calculate out the avarage value and make single-line graphics.

    Capture.PNG

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: How to fix this graphic

    I'm sure there is, though I would note that charts tend not to analyze data for us. I would suggest that you need to perform the needed data analysis in the spreadsheet, then use that data in the chart. It is not clear to me exactly what kind of analysis you would perform, but I would expect an "averaging" analysis to involve the AVERAGE(), AVERAGEIF(), or AVERAGEIFS() functions somehow. https://support.office.com/en-us/art...8-f7c5c3001690
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-22-2017
    Location
    Latvia
    MS-Off Ver
    Windows 10
    Posts
    3

    Re: How to fix this graphic

    I have filled 15000 cells. For example: in picture you can see in left collon two diffrent numbers(20 and 30) Each opposite this figure is 34 different values. I want, that excel take avarege.

    Capture.PNG

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: How to fix this graphic

    I don't understand what you want. Going with the conditional average I was thinking of before, are you looking for =AVERAGEIFS(column2,column1,20)?

  5. #5
    Registered User
    Join Date
    03-22-2017
    Location
    Latvia
    MS-Off Ver
    Windows 10
    Posts
    3

    Re: How to fix this graphic

    I left colonn I have numbers with step 10. (10, 20, 30, 40, 50, 60, ....20000) and for each of this number is 34 measurements.
    Thats why graphic is so wide but I need that excel take avarage from 34 measurements. I watched your mentioned function but I think
    it's not for this situation. Or I am wrong?

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: How to fix this graphic

    I watched your mentioned function but I think it's not for this situation. Or I am wrong?
    I don't know. The example AVERAGEIFS() function I gave would return the average value for all of the "20" entries, which is what you seem to be asking for. What result does this function give you? What result were you expecting? If they are different, how did you calculate the value you were expecting?

  7. #7
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,572

    Re: How to fix this graphic

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson

+ 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. graphic
    By Oswald Stuart in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-17-2012, 06:35 PM
  2. Graphic difference
    By koi in forum Excel General
    Replies: 1
    Last Post: 01-17-2012, 10:52 AM
  3. How to name graphic files
    By rfhall50 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-04-2011, 09:19 AM
  4. graphic animation
    By excelstudent in forum Excel General
    Replies: 4
    Last Post: 01-28-2010, 09:35 PM
  5. Graphic X=cte
    By alfred33 in forum Excel General
    Replies: 2
    Last Post: 10-14-2006, 07:32 PM
  6. About lineal graphic
    By Miguel Angel in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-28-2006, 05:35 AM
  7. [SOLVED] Graphic Indicator
    By WTPB041 in forum Excel General
    Replies: 2
    Last Post: 02-14-2006, 11:44 PM
  8. [SOLVED] a strange graphic
    By filo666 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2006, 12:45 PM

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