| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dates change in X axis! Need help ASAP Please?
My dilemma is logarithmic charts. I can get the Y axis to do what I want,
but the X axis is more difficult. We need a true time X axis. Ex: 6/27/01, 12/7/01, 6/28/02, 3/04/03, etc. The dates are not equally separated. Question 1: Can this be plotted? When I do create the chart, the dates all change to Ex: 6/01/01, 12/01/01, 6/01/02., etc. The €œday€ switches to all 01. So frustrating. Question 2: How do I keep the dates true? Can you help? There HAS to be a simple explanation, right? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dates change in X axis! Need help ASAP Please?
If there truly is no pattern to the x-axis:
Under Chart options, can you change the x-axis to category? Note that this will require that your raw data is in order, to be displayed correctly. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Delyga" wrote: My dilemma is logarithmic charts. I can get the Y axis to do what I want, but the X axis is more difficult. We need a true time X axis. Ex: 6/27/01, 12/7/01, 6/28/02, 3/04/03, etc. The dates are not equally separated. Question 1: Can this be plotted? When I do create the chart, the dates all change to Ex: 6/01/01, 12/01/01, 6/01/02., etc. The €œday€ switches to all 01. So frustrating. Question 2: How do I keep the dates true? Can you help? There HAS to be a simple explanation, right? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dates change in X axis! Need help ASAP Please?
Luke:
My x-axis consists of dates. 6/27/01 12/7/01 6/28/02 1/2/03 6/5/03 2/3/04, etc. We need these as the x-axis, but showing spaces between the dates as real time... not equally spaced. Is this possible? Thanks for your quick response! Delyga "Luke M" wrote: If there truly is no pattern to the x-axis: Under Chart options, can you change the x-axis to category? Note that this will require that your raw data is in order, to be displayed correctly. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Delyga" wrote: My dilemma is logarithmic charts. I can get the Y axis to do what I want, but the X axis is more difficult. We need a true time X axis. Ex: 6/27/01, 12/7/01, 6/28/02, 3/04/03, etc. The dates are not equally separated. Question 1: Can this be plotted? When I do create the chart, the dates all change to Ex: 6/01/01, 12/01/01, 6/01/02., etc. The €œday€ switches to all 01. So frustrating. Question 2: How do I keep the dates true? Can you help? There HAS to be a simple explanation, right? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dates change in X axis! Need help ASAP Please?
Also... I was able to keep the dates true (not change from original dates to
6/01/01, 12/01/01, etc.). Now the questions is the spacing between the dates as if they were true. They obviously don't read 2/2/99, 3/2/99, 4/2/99, etc. "Luke M" wrote: If there truly is no pattern to the x-axis: Under Chart options, can you change the x-axis to category? Note that this will require that your raw data is in order, to be displayed correctly. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Delyga" wrote: My dilemma is logarithmic charts. I can get the Y axis to do what I want, but the X axis is more difficult. We need a true time X axis. Ex: 6/27/01, 12/7/01, 6/28/02, 3/04/03, etc. The dates are not equally separated. Question 1: Can this be plotted? When I do create the chart, the dates all change to Ex: 6/01/01, 12/01/01, 6/01/02., etc. The €œday€ switches to all 01. So frustrating. Question 2: How do I keep the dates true? Can you help? There HAS to be a simple explanation, right? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Dates change in X axis! Need help ASAP Please?
I don't see anything close to "category" selection. Sorry!
"Delyga" wrote: Also... I was able to keep the dates true (not change from original dates to 6/01/01, 12/01/01, etc.). Now the questions is the spacing between the dates as if they were true. They obviously don't read 2/2/99, 3/2/99, 4/2/99, etc. "Luke M" wrote: If there truly is no pattern to the x-axis: Under Chart options, can you change the x-axis to category? Note that this will require that your raw data is in order, to be displayed correctly. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Delyga" wrote: My dilemma is logarithmic charts. I can get the Y axis to do what I want, but the X axis is more difficult. We need a true time X axis. Ex: 6/27/01, 12/7/01, 6/28/02, 3/04/03, etc. The dates are not equally separated. Question 1: Can this be plotted? When I do create the chart, the dates all change to Ex: 6/01/01, 12/01/01, 6/01/02., etc. The €œday€ switches to all 01. So frustrating. Question 2: How do I keep the dates true? Can you help? There HAS to be a simple explanation, right? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Y axis data point alignment with x axis dates | Charts and Charting in Excel | |||
| How do I change where category x axis crosses the 2nd y axis? | Charts and Charting in Excel | |||
| Calculate Follow-Up Dates - Please help ASAP | Excel Worksheet Functions | |||
| $values on y axis % change on x axis | Charts and Charting in Excel | |||
| How do I change X-Axis values in a chart with 2 Y-Axis? | Charts and Charting in Excel | |||
Linear Mode
