Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts
hi, i have data on different sheets in a workbook. the data on the
first sheet is a name corresponding to which there is an amount in the next cell. On the second sheet too, the same name appears but with a different amount next to it. Is it possible to create a graph based on the two values. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Charts
what kind of graph do you want to make?
to get the data together, Use an empty column next to the data in the first sheet, if names are in A and Data in B and column C were empty, in C1 enter =if(iserror(Vlookup(A1,"Sheet2'!A:B,2,0)),"",Vlook up(A1,"Sheet2'!A:B,2,0)) copy down now you will have the data side by side "tc" wrote: hi, i have data on different sheets in a workbook. the data on the first sheet is a name corresponding to which there is an amount in the next cell. On the second sheet too, the same name appears but with a different amount next to it. Is it possible to create a graph based on the two values. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
interactive charts for stacked bar charts | Charts and Charting in Excel | |||
Combine Clustered Column Bar charts and Stacked column bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
3-D Charts | Charts and Charting in Excel | |||
Charts | New Users to Excel |