Excel is adding 2 rows of data source together when charting

  • Thread starter Thread starter Leona
  • Start date Start date
L

Leona

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!
 
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
 
Back
Top