Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
My 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. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
My data points disappear
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 _______ "Albebach" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
My data points disappear
I want the years to range from 1990 to 2007. And my "y" values have a range
of $0 to $650,000. "Jon Peltier" wrote: 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 _______ "Albebach" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
My data points disappear
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 _______ "Albebach" wrote in message ... I want the years to range from 1990 to 2007. And my "y" values have a range of $0 to $650,000. "Jon Peltier" wrote: 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 _______ "Albebach" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why does the 'data' button disappear... | Charts and Charting in Excel | |||
Why does my data disappear? | Charts and Charting in Excel | |||
Why does some of my data disappear | Excel Discussion (Misc queries) | |||
Pivot charts - data disappear after selecting or data are static | Excel Worksheet Functions | |||
Data labels disappear | Charts and Charting in Excel |