| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
how to make the axis of charts to start at my lowest value(data)?
actually, i am making a chart with values starting at 40 to 85.
when i plot the chart, it is located somewhere in the middle upto the end because excel tries to plot 0 to 40 on my x axis which i do not want. what i want is that the x-axis of my chart should start at 40 then probably by interval of five upto 85. also my y-axis to start at 140 upto ~180. here is my data. x y 72 160 54 149 78 152 84 171 62 153 57 158 49 142 68 164 75 166 56 150 60 160 50 141 80 166 45 136 52 129 55 159 pls help. thanks. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to make the axis of charts to start at my lowest value(data)?
Hi,
Rightclick on the X-axis -- "Format Axis" -- click on the "Scale" Tab -- set "Minimum" to 40 -- "Maximum" to 85 -- "Major Unit" to 5 -- "OK" Follow a similar procedure to format the Y-axis. Regards, B. R. Ramachandran "wendell remolador" wrote: actually, i am making a chart with values starting at 40 to 85. when i plot the chart, it is located somewhere in the middle upto the end because excel tries to plot 0 to 40 on my x axis which i do not want. what i want is that the x-axis of my chart should start at 40 then probably by interval of five upto 85. also my y-axis to start at 140 upto ~180. here is my data. x y 72 160 54 149 78 152 84 171 62 153 57 158 49 142 68 164 75 166 56 150 60 160 50 141 80 166 45 136 52 129 55 159 pls help. thanks. |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
how to make the axis of charts to start at my lowest value(dat
wow thank u sir. just what i need.. ^_^
"B. R.Ramachandran" wrote: Hi, Rightclick on the X-axis -- "Format Axis" -- click on the "Scale" Tab -- set "Minimum" to 40 -- "Maximum" to 85 -- "Major Unit" to 5 -- "OK" Follow a similar procedure to format the Y-axis. Regards, B. R. Ramachandran "wendell remolador" wrote: actually, i am making a chart with values starting at 40 to 85. when i plot the chart, it is located somewhere in the middle upto the end because excel tries to plot 0 to 40 on my x axis which i do not want. what i want is that the x-axis of my chart should start at 40 then probably by interval of five upto 85. also my y-axis to start at 140 upto ~180. here is my data. x y 72 160 54 149 78 152 84 171 62 153 57 158 49 142 68 164 75 166 56 150 60 160 50 141 80 166 45 136 52 129 55 159 pls help. thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Make Exec work properly (error messages on start and exit) | Excel Discussion (Misc queries) | |||
| make line in chart start at y axis | Charts and Charting in Excel | |||
| How do I make a custom category axis? | Charts and Charting in Excel | |||
| How do I make the Y axis in an excel chart the category axis? | Charts and Charting in Excel | |||
| How do I make my settings suggest previous words as I start to ty. | Excel Discussion (Misc queries) | |||
Linear Mode
