Prev: How do I prevent a text box from printing in XL2007?
Next: Graph does not copy with the tab
From: Leona on 25 Feb 2010 14:34
I'm trying to create a simple chart that shows trending during the year. I
have several rows of data -- 1/2 of them being actual financial performance
numbers and the other 1/2 being budget numbers. When I select the data
ranges, whether using the Control Key to select all ranges at once, OR by
selecting them individually, some of my data ranges are being added together,
resulting in the ranges NOT reflecting what the source table numbers are.
The ranges appear to be correct. I've tried crafting each range individually
with the same result. Why is this happening? What am I doing wrong? Fix?
Thanks!
From: Bernard Liengme on 25 Feb 2010 15:30
Do you mean your have:
row 1: budget
row 2: actual
row 3: budget
row 4: actual
That is not going to work to make a chart unless you
1) make an XY chart chart form rows 1 &2
2) select rows 3 & 4, copy; click chart; on Home tab, open Paste and use
paste special specifying New Series, x-values in first row
3) repeat step 2 with next pair of rows
OR
massage data into two rows (or using Past Special -> transpose) into two
columns
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Leona" <Leona(a)discussions.microsoft.com> wrote in message
news:F438F404-4390-41B6-A8BD-FD007E3F94A7(a)microsoft.com...
> I'm trying to create a simple chart that shows trending during the year.
> I
> have several rows of data -- 1/2 of them being actual financial
> performance
> numbers and the other 1/2 being budget numbers. When I select the data
> ranges, whether using the Control Key to select all ranges at once, OR by
> selecting them individually, some of my data ranges are being added
> together,
> resulting in the ranges NOT reflecting what the source table numbers are.
> The ranges appear to be correct. I've tried crafting each range
> individually
> with the same result. Why is this happening? What am I doing wrong?
> Fix?
> Thanks!

 | 
Pages: 1
Prev: How do I prevent a text box from printing in XL2007?
Next: Graph does not copy with the tab