If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#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! |
Thread Tools | |
Display Modes | |
|
|