 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / April 2008My data points disappear
I'm trying to create a regulart line graph from a set of data. Everytime I try to change the x-axis to timescale it automatically changes my y-axis data range and my data points disappear. So then I go and change the y-axis data range back to what is was but my data points and line graph won't show. Please help. I suspect it's a mismatch of X values, not Y values. What are the X and Y values in your chart series, and what range are you trying to plot on your time scale axis? - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ > I'm trying to create a regulart line graph from a set of data. Everytime > I [quoted text clipped - 4 lines] > range back to what is was but my data points and line graph won't show. > Please help. I want the years to range from 1990 to 2007. And my "y" values have a range of $0 to $650,000. > I suspect it's a mismatch of X values, not Y values. What are the X and Y > values in your chart series, and what range are you trying to plot on your [quoted text clipped - 15 lines] > > range back to what is was but my data points and line graph won't show. > > Please help. Are the X values just in years? Make your life easier and make an XY chart. You can connect the markers with lines. If the first year is 1990, does the first date look like 6/12/1905? That's the 1900th day in Excel's calendar. To make the time axis work with a line chart, enter your dates as complete dates, like 1/1/1990. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ >I want the years to range from 1990 to 2007. And my "y" values have a >range [quoted text clipped - 22 lines] >> > range back to what is was but my data points and line graph won't show. >> > Please help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.