Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hello,
Using Excel 2007 and XP. I have some tabular data arranged next to a column that has dates starting from July 1, and labeled vertically downward to Dec. 31. However, although they are for this year, there is no year that I have indicated. When I chart the data, the only way I can get it to show up is to do the Default chart and automatic for the horiz (date) axis. If I try to set the min and max limits for the axis (whic I would like to do), the data points do not appear. I'm assuming that they are there, somewhere, but off the chart. Questions: What year is Excel probably assuming for my data ? How can I find out the data number (the number of days from wherever it starts from) it is working with ? - for the dates I have in my data column ? - for the chart itself ? Hope I've explained this well enough. Probably a common problem for new users like me. How also does one avoid this "problem" ? Thanks, Bob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data to Chart Question/How-to | Charts and Charting in Excel | |||
Chart Question regarding number of data points | Charts and Charting in Excel | |||
question best way to organze data for this chart | New Users to Excel | |||
Chart question | Excel Discussion (Misc queries) | |||
Pivot Chart Data Label Format Question | Excel Discussion (Misc queries) |