Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
proper scaling in chart (with time-scale X-axis)
I have a chart with the following data:
x y - - 1 1 1.25 1.25 2 2 3 3 5 5 I expect to see a chart with a straight line graph. The only way I can get the X-axis to scale is to go into Chart Options-Axis- Category (X) axis-Time-Scale and then format the X-axis as a number as opposed to a date. However, this still treats my data as dates so that 1 and 1.25 show up on the same point on the X-axis (1). Is there any way to "number" scale my X-axis or some other approach to accomplish this goal of my X-axis scaling along with the values? Thanks. Edward |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
proper scaling in chart (with time-scale X-axis)
use the xy chart rather than the line chart
"Edward" wrote: I have a chart with the following data: x y - - 1 1 1.25 1.25 2 2 3 3 5 5 I expect to see a chart with a straight line graph. The only way I can get the X-axis to scale is to go into Chart Options-Axis- Category (X) axis-Time-Scale and then format the X-axis as a number as opposed to a date. However, this still treats my data as dates so that 1 and 1.25 show up on the same point on the X-axis (1). Is there any way to "number" scale my X-axis or some other approach to accomplish this goal of my X-axis scaling along with the values? Thanks. Edward |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
proper scaling in chart (with time-scale X-axis)
On May 24, 3:37 pm, bj wrote:
use the xy chart rather than the line chart "Edward" wrote: I have a chart with the following data: x y - - 1 1 1.25 1.25 2 2 3 3 5 5 I expect to see a chart with a straight line graph. The only way I can get the X-axis to scale is to go into Chart Options-Axis- Category (X) axis-Time-Scale and then format the X-axis as a number as opposed to a date. However, this still treats my data as dates so that 1 and 1.25 show up on the same point on the X-axis (1). Is there any way to "number" scale my X-axis or some other approach to accomplish this goal of my X-axis scaling along with the values? Thanks. Edward- Hide quoted text - - Show quoted text - Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
How chart time scale x-axis with another date serie | Charts and Charting in Excel | |||
Scaling time on the x-axis of a graph | Excel Discussion (Misc queries) | |||
Scaling x-axis with time | Charts and Charting in Excel | |||
2 Axis chart and scaling | Charts and Charting in Excel |