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
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
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
Originally Posted by shg
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
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)?
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?
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?I watched your mentioned function but I think it's not for this situation. Or I am wrong?
(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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks