ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Excel is adding 2 rows of data source together when charting (https://www.excelbanter.com/charts-charting-excel/257411-excel-adding-2-rows-data-source-together-when-charting.html)

Leona

Excel is adding 2 rows of data source together when charting
 
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!

Bernard Liengme[_2_]

Excel is adding 2 rows of data source together when charting
 
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" wrote in message
...
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!




All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com