Windows 7 Forums Search
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows 7. The Windows 7 forum also covers news and updates and has an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7 - Can't add values to Excel graph.

 
02-06-2012   #1


Windows 7 Professional x64 SP 1
 
 

Can't add values to Excel graph.

I just can't get new data to display on this graph (see below):



I enter the values in the table on the left, and they won't show up in the graph! This has just started happening, as you see, the first six sets of values are displaying fine.

Why?!

I have the correct cells selected, by the way.

My System SpecsSystem Spec
02-06-2012   #2


Windows 7 Professional x64 SP 1
 
 


Well, I would've posted an image, but it just won't display, whatever I do.

Ah, it's just one of those days, ain't it...
My System SpecsSystem Spec
02-06-2012   #3


32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Several flavors of Linux
 
 


  1. Click on graph.
  2. Right-click and click Select data...
  3. Make sure the Chart data range covers your data set.

If that doesn't do it, I'll look into something else.

Regards,
GEWB
My System SpecsSystem Spec
.


02-06-2012   #4


Windows 7 SP1, Home Premium, 64-bit
 
 


Generally, to force trend lines to extend farther to right, right click chart and choose select data; then edit horizontal axis labels so they include the new dates.
My System SpecsSystem Spec
02-06-2012   #5


Windows 7 Professional x64 SP 1
 
 


I've checked the data range, and also tried adding new dates. No joy! Nothing I've tried will convince the thing to display the new numbers. What makes it even weirder is that I have a similar graph on another sheet in the workbook which has over 30 values in it, and it displays everything I enter in it. I can't see any difference between the two!
My System SpecsSystem Spec
Reply

 Can't add values to Excel graph. problems?



Thread Tools



Similar Threads for: Can't add values to Excel graph.
Thread Forum
Hex values of fonts General Discussion
Auto generate a graph help Software
Formatting Excel 2010, Excel 2003 Microsoft Office
Can't open 2003 Excel Files in Excel 2007? Microsoft Office
Excel 2003 - Multiple Excel Open Microsoft Office


All times are GMT -5. The time now is 05:59 PM.



Windows 7 Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows 7" and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30