I want to have line chart
In Column B i have Names and Column C number values. So extract the individual points it would be IF B="x" then C, but im struggling i think it might needs to use dynamic ranges.
Any help would aprreicated
I want to have line chart
In Column B i have Names and Column C number values. So extract the individual points it would be IF B="x" then C, but im struggling i think it might needs to use dynamic ranges.
Any help would aprreicated
HOW TO ATTACH YOUR SAMPLE WORKBOOK:
oeldere Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I have attached a sample
With a pivot table and pivot graph.
See the attached file.
Not clear how the result range should look like.
You need to elaborate what exactly should happen to individual values not relevant (not plot, leave gap etc.).
It's hard to visualise or second guess what exactly you have in mind.
Attached is two possibilities, depending what you want to do.
It should be self-explanatory.
Scatter chart is chosen for convenience to ignore/not plot error values and therefore make the chart (x-axis) dynamic.
Regards
Sorry if i was unclear, Thanks very much for your help!
@buyshirts
Since you got answers of several forummembers it is good to add to whom you replying.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks