change scale y axis interval values excel for mac

Change Scale Y Axis Interval Values Excel How To Make The

If i use x-y scatter, the x-axis spacing is correct (points are proportional to the time), but i cant get an area chart.

If I use the area chart, the observations are all spaced equally along the x axis.

Change Scale Y Axis Interval Values Excel How To Make The

Does anyone know how to make the x-axis plot time for normal charts.

Other types of charts, such as column, line, and area, have a value axis (Y) and a category axis (X) which ignores any apparent numerical values in its data.

You can get a pseudo-numerical axis if you select a time-scale axis rather than a category axis (Chart menu - Chart Options - Axes tab), but it only does dates (whole numbers), not times (fractional numbers).

Your best option is to think about why you need the area chart formatting, and to see whether you can convince yourself to use a scatter chart.

If after all of this, you still must use an area chart type, read the following web page, which explains how to apply area chart formatting in a scatter chart.

My plotted y-values are just int numbers like 1, 2, 3,., 10.

Nevertheless the left y-axis shows values like 6.3, 9.1, etc., depending on my zoom level.

The second question is, how to setup the x-axis in order to show the labels 1,5,10,15,.40.

Im kind of short on time right now but I wanted to give you an answer anyway, so you should just look at the axis features, or look at the demos:-).

Is there a way to fixate on the maximum and minimum values for Y-axis in Combined Chart.

You have no idea how easy you guys have made life for us developers.

Change Scale Y Axis Interval Values Excel For Mac