| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can a Vlookup be used when creating a chart
1. Is it possible?
2. where would it be entered? the values line? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a Vlookup be used when creating a chart
1. Probably
2. Not enough detail to provide even a guess. Gord Dibben MS Excel MVP On Tue, 26 Jan 2010 11:23:02 -0800, Confusicous wrote: 1. Is it possible? 2. where would it be entered? the values line? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a Vlookup be used when creating a chart
Here is my data:
2010 spreadsheet = Entities = A18:A45 Numbers = N18:N45 2009 spreadsheet= Entities A18:A41 Numbers = N18:N41 The reason I would like to have the Vlookup is because new data was entered in 2010 but if I just enter the data my figures are off because of the new entities in 2010. I am looking to have the entities on the X axis and the numbers on the Y axis. My Vlookup would be based on the entities but I don't know how to get that to translate into the chart... "Gord Dibben" wrote: 1. Probably 2. Not enough detail to provide even a guess. Gord Dibben MS Excel MVP On Tue, 26 Jan 2010 11:23:02 -0800, Confusicous wrote: 1. Is it possible? 2. where would it be entered? the values line? . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a Vlookup be used when creating a chart
I don't understand the problem.
Which worksheet are you charting and which range? 2010 or 2009 Which figures are off? Gord On Tue, 26 Jan 2010 12:55:01 -0800, Confusicous wrote: Here is my data: 2010 spreadsheet = Entities = A18:A45 Numbers = N18:N45 2009 spreadsheet= Entities A18:A41 Numbers = N18:N41 The reason I would like to have the Vlookup is because new data was entered in 2010 but if I just enter the data my figures are off because of the new entities in 2010. I am looking to have the entities on the X axis and the numbers on the Y axis. My Vlookup would be based on the entities but I don't know how to get that to translate into the chart... "Gord Dibben" wrote: 1. Probably 2. Not enough detail to provide even a guess. Gord Dibben MS Excel MVP On Tue, 26 Jan 2010 11:23:02 -0800, Confusicous wrote: 1. Is it possible? 2. where would it be entered? the values line? . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Can a Vlookup be used when creating a chart
I am going to be charting both...there will be 2bars on the graph for each
entity. so the chart figures for 2010 would be off since 2009 doesn't include the new entities "Gord Dibben" wrote: I don't understand the problem. Which worksheet are you charting and which range? 2010 or 2009 Which figures are off? Gord On Tue, 26 Jan 2010 12:55:01 -0800, Confusicous wrote: Here is my data: 2010 spreadsheet = Entities = A18:A45 Numbers = N18:N45 2009 spreadsheet= Entities A18:A41 Numbers = N18:N41 The reason I would like to have the Vlookup is because new data was entered in 2010 but if I just enter the data my figures are off because of the new entities in 2010. I am looking to have the entities on the X axis and the numbers on the Y axis. My Vlookup would be based on the entities but I don't know how to get that to translate into the chart... "Gord Dibben" wrote: 1. Probably 2. Not enough detail to provide even a guess. Gord Dibben MS Excel MVP On Tue, 26 Jan 2010 11:23:02 -0800, Confusicous wrote: 1. Is it possible? 2. where would it be entered? the values line? . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a mix of column and scatter chart on one chart. | Charts and Charting in Excel | |||
| I need help in creating a chart | Charts and Charting in Excel | |||
| Creating a chart(? pie chart) that shows customers,dates and machi | Charts and Charting in Excel | |||
| Creating a Pie Chart | Charts and Charting in Excel | |||
| 2 way Vlookup - Creating array arguments from columns | Excel Discussion (Misc queries) | |||
Linear Mode
