Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show a bigger gap between non equadistant dates in Excel
I am so frustrated! I am trying to enter data that has 3 different dates not
equally distant and want to show on the associated chart that there is a bigger gap between 1 and 2 (5 months) than between 2 and 3 (one month). Can anyone please help. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show a bigger gap between non equadistant dates in Excel
If you have a BAR chart, I'd suggest this. Let's say you have data for
1/05, 3/05 and 8/05. Why not have X labels for 1/05, 2/05, 3/05, 4/05, ... 8/05, but only enter Y values for the months of interest. If you have a LINE chart, why not change it to XY Scatter. "Grace Poole" <Grace wrote in message ... I am so frustrated! I am trying to enter data that has 3 different dates not equally distant and want to show on the associated chart that there is a bigger gap between 1 and 2 (5 months) than between 2 and 3 (one month). Can anyone please help. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show a bigger gap between non equadistant dates in Excel
Convert the x-axis to a 'time scale.' Select the chart, then select
Chart | Chart Options... | Axes tab. In there, set the Category (X) axis to 'Time-scale'. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=? Utf-8?B?R3JhY2UgUG9vbGU=?=" <Grace says... I am so frustrated! I am trying to enter data that has 3 different dates not equally distant and want to show on the associated chart that there is a bigger gap between 1 and 2 (5 months) than between 2 and 3 (one month). Can anyone please help. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I show a bigger gap between non equadistant dates in Excel
Make sure that the values are interpreted by Excel as numerical dates, and
not just labels. Normally if Excel recognizes dates in the category range, it will automatically select the time scale axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Tushar Mehta" wrote in message om... Convert the x-axis to a 'time scale.' Select the chart, then select Chart | Chart Options... | Axes tab. In there, set the Category (X) axis to 'Time-scale'. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , "=? Utf-8?B?R3JhY2UgUG9vbGU=?=" <Grace says... I am so frustrated! I am trying to enter data that has 3 different dates not equally distant and want to show on the associated chart that there is a bigger gap between 1 and 2 (5 months) than between 2 and 3 (one month). Can anyone please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
Why won't Excel buttons show separately on the taskbar? | Excel Discussion (Misc queries) | |||
how do I select unique dates from a database in Excel? | Excel Worksheet Functions | |||
How can I show Feet and inches in a Excel cell? | Excel Discussion (Misc queries) | |||
micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions |