Replies

it would be type B on http://welfarestate.com/Excel-Data-Matching-Merger/ but that script doesn’t seem to work on excel 2013

you’re just combing data based on the matching ids/label and duplicating them

i mean you’re just merging two sheets that have different label for the columns

the only column that has the same label is A1

and A2:A1000 is what should be matched and not duplicated

first sheet is just data from A-C1 : A-C1000

the same as the sheet you want to merge with

only difference is A2:A1000 would have similar ids/labels so the id would need to match upon merge and not be duplicated (the consolidate video shows how the outcome would be)

the first post describes what the problem is though.

everything is already there in the first 2 post for an advice to the problem

sadly i need to request for aid again as i realised far too late that ‘consolidate, from what i understand, only does numerical data…

advise please?

*** THANKS SO MUCH!!

sorry i could i not explain this any better :/

i found what i needed — http://www.youtube.com/watch?v=NYX3x32CeSg

i needed to know what the word ‘consolidate’ in excel meant. this is by labels, so ‘top row’ and left column’

this is for making a map!

i finally figured out how to put in the data to get the multiple lines…..

btw, the post was really really confusing. the post wasn’t very descriptive “range” and i don’t know what ‘location’ means

if range means A1:A100, then that makes a lot more sense to someone new

i also don’t understand what ‘array’ means and all of this could’ve been explained much user-friendly

i did… i right click on the scatterplot with straight line and click ‘select data’ and the ‘edit’ button is still blanked out…..

excel 2013

yes im new, in that i haven’t done these kind of things

though misunderstanding is pretty high. i clearly said that i did not want to do it the easy way — “click on insert, whatever chart you want, and Excel will use that data selection to chart the information” — for the reasons already mentioned

here are the specifics so you can see what im stuck on:
after right-clicking on an empty line chart,
*what am i suppose to put in “chart data range” at the top of the popup?
*when adding a “series” why does “series Y values” have ={1}? this is so confusing. am i suppose to replace the whole thing, or just replace the {1}, or not just add *whatever after this? very confusing. need a guide.
*how do i “edit” the “horizontal axis labels”?? it’s blanked out

i really just need a guide or good links in how to create a chart (manually, which means not the easy way)

none is about “select data” — the first part is just about the easy way and the rest is just about presentation. it completely skipped the “select data” part

the only thing related to “select data” is how to select, but it doesn’t tell you what or where

any better guides?

im asking how to create the chart in the first place

the data is not in the clean format you have

when you right click on an empty chart, you have to put in data “select data”

i don’t know how to use this.

it’s very confusing, and i couldn’t find any guides, they were all about the easy way –> insert, etc.

i just need to know conceptually what to put where and i can do it

also there are many ways to do that line graph thing, and i needed to know what would be the most flexible way

it’s the same, just how do you do it without this method — “insert –> line –> and under 2d line”

how do you do it manually (inputting data into those “series” boxes)?

it’s like http://www.telerik.com/help/aspnet-ajax/media/htmlchart-linechart-simple-example.png — only it has a lot of lines

i’ll try to do a drawing…

so basically you have a box
inside the box you have a line going from left to right
you have mutiple lines and they can overlap each other so it would look like “insert –> line –> and under 2d line”

that’s basically it

so just how do you make a line graph that has mutiple lines

hope that helps

same with the autosave backups — there are none