Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


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

06 Feb 2012   #1
DeniqueCoelum

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):

[IMG]http://www.**************/imgbnc.php/628220c5ad14e56fcc9c18f3a30331450461e373d13e7498ffb7e5c39e8d57af6g.jpg[/IMG]

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
.

06 Feb 2012   #2
DeniqueCoelum

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
06 Feb 2012   #3
GEWB

32bit: XP, Win7 H.P. / 64bit: 2008R2, Win7 Pro, Ultimate / Win8.1 / 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
.


06 Feb 2012   #4
ignatzatsonic

Microsoft Community Contributor Award Recipient

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
06 Feb 2012   #5
DeniqueCoelum

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.




Thread Tools





Similar help and support threads
Thread Forum
*** Simple Muti-Series Line Graph ***
Goal: produce a line graph with these conditions * multiple lines (series) of K ** going across the graph using X data (horizontal axis) *** by Y (vertical axis) i don't know what to look for. the information out there is a mess, and it's hard to separate the garbage from the quality,...
Microsoft Office
How do I see the X axis values with Excel 2010
Hi, I know it's a basic question -- and I've been charting with Excel for a while; but now all of a sudden when I make a Line Chart with Excel 2010; the horizonital values shown are just sequential numbers of the real X values. How do I get Excel to show the actual X values on the horizonital...
Microsoft Office
Auto generate a graph help
Can any one help me find an app that will help me do this? I want to automatically generate a line graph from a text CSV file that is automatically and constantly generated by another software I have running. Then I want the graph to be displayed/posted to a particular directory on my website,...
Software
xperf disk io graph about flushes item
hi all, I have a question about an xperf diskI/O's item. whats meaning of flushes item of the diskI/O? Does it mean that write the log file to disk or other issue? there is its screenshot: http://i.imgur.com/T85et.jpg Why only my driver c has the flushes operation? (as the screenshot of...
Performance & Maintenance
Reliability Monitor Graph not working
Windows 7 Reliability Monitor Graph problem. I have 2 computers, both exactly the same hardware, running Windows 7 Home premium installed at the same time on both computers. (January 2010) The reliability monitor graph in one computer works as it should showing the details and reliability index....
Performance & Maintenance
Reliability Monitor Wont Display Graph
Im having a really tough to TS problem with the reliability monitor. For the last week, it no longer displays any data and the graph dosent render. It just display as blank with no data. Some things to note... 1. The RAC published and State data are being updated and published each day as...
Performance & Maintenance

Our Sites

Site Links

About Us

Find Us

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

All times are GMT -5. The time now is 14:43.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App