| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Line chart- exact intervals
I want to make a user defined line chart with dates on the bottom that
correspond to the exact dates in Column 1 of my worksheet. The line chart wizard places the dates at even intervals, but I need exact dates. -- betty |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line chart- exact intervals
1. Make sure the dates in the worksheet are numerical dates, not text.
2. Chart menu Chart Options Axes tab, change Category (X) Axis type to Time Scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "betty" wrote in message ... I want to make a user defined line chart with dates on the bottom that correspond to the exact dates in Column 1 of my worksheet. The line chart wizard places the dates at even intervals, but I need exact dates. -- betty |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line chart- exact intervals
I've done that, but it still isn't giving exact dates. The date column is
formatted as dates and the numbers column is formatted as number, one decimal place. -- betty "Jon Peltier" wrote: 1. Make sure the dates in the worksheet are numerical dates, not text. 2. Chart menu Chart Options Axes tab, change Category (X) Axis type to Time Scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "betty" wrote in message ... I want to make a user defined line chart with dates on the bottom that correspond to the exact dates in Column 1 of my worksheet. The line chart wizard places the dates at even intervals, but I need exact dates. -- betty |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Line chart- exact intervals
Double click the axis, and on the scale tab, change the base unit to Days.
- Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "betty" wrote in message ... I've done that, but it still isn't giving exact dates. The date column is formatted as dates and the numbers column is formatted as number, one decimal place. -- betty "Jon Peltier" wrote: 1. Make sure the dates in the worksheet are numerical dates, not text. 2. Chart menu Chart Options Axes tab, change Category (X) Axis type to Time Scale. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "betty" wrote in message ... I want to make a user defined line chart with dates on the bottom that correspond to the exact dates in Column 1 of my worksheet. The line chart wizard places the dates at even intervals, but I need exact dates. -- betty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
| To separate two line in a line chart | Charts and Charting in Excel | |||
| Bar Chart To Line Chart for last 3 points only | Charts and Charting in Excel | |||
| Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
| Line chart - date line association gone mad! | Charts and Charting in Excel | |||
Linear Mode
