Prev: XY Charts Excluding Weekends
Next: How do I move a chart using a macro?
From: Confusicous on 26 Jan 2010 14:14
I am trying to make a chart that shows 2009 numbers versus 2008 numbers and
here is my issue: I have 4 cities Chicago(A1), Dallas(A2), Detroit(A3), and
Los Angeles(A4) that I have for 2008 and 2009 but I added 2 cities for 2009.
Is there a way to do a vlookup to pull the data for the chart or do I have to
set up the data sheets the same way...I tried to make this short so sorry if
its not enough info, just let me know if I can clear something up.

Thanks in advance
From: Bernard Liengme on 26 Jan 2010 14:31
You should put your new cities in A5 and A6 (just their names --- <grin>)
In B5 and B6 enter =NA() which will display as #N/A and be ignored by the
charting engine
In C5:C6 you could type new data or use any formula you like to extract it
from elsewhere on the same or another workbook.
Unless you arrange to make the chart automatically extend: click the chart
area and drag the range finders in A1:C4 down to row 6 to 'capture' the new
data into the chart.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Confusicous" <Confusicous(a)discussions.microsoft.com> wrote in message
news:D9CD5DE8-D404-4AD2-9121-82763A414887(a)microsoft.com...
> I am trying to make a chart that shows 2009 numbers versus 2008 numbers
> and
> here is my issue: I have 4 cities Chicago(A1), Dallas(A2), Detroit(A3),
> and
> Los Angeles(A4) that I have for 2008 and 2009 but I added 2 cities for
> 2009.
> Is there a way to do a vlookup to pull the data for the chart or do I have
> to
> set up the data sheets the same way...I tried to make this short so sorry
> if
> its not enough info, just let me know if I can clear something up.
>
> Thanks in advance

 | 
Pages: 1
Prev: XY Charts Excluding Weekends
Next: How do I move a chart using a macro?