how to make a subscript in excel for mac graph axis

When I click the mouse, Excel builds the chart.

The first preview shows what we want - this chart shows markers only, plotted with height on the horizontal axis and weight on the vertical axis. Here I'll select all data for height and weight, then click the scatter icon next to recommended charts. When creating scatter charts, it's generally best to select only the X and Y values, to avoid confusing Excel.

Let's create a scatter plot to show how height and weight are related. On this worksheet, we have the height and weight for 10 high school football players. A scatter chart has a horizontal and vertical axis, and both axes are value axes designed to plot numeric data. A scatter plot or scatter chart is a chart used to show the relationship between two quantitative variables. In this video, we'll look at how to create a scatter plot, sometimes called an XY scatter chart, in Excel. You can change this row and column setup. Total six video tutorials will guide you to learn Excel charting So to identify a date point in the chart, I am moving along the X axis at first, and then moving along the Y axis. In my TI-89, I don't even have a log button so I have to use ln for everything (there is a function for programming which I can use for any meaningful base).A complete video tutorial on How to Make or Plot a Graph or Chart in Excel 2013. In the above, the base 7 is changed first to 10, then to e, then to 134, all of them yielding the same answer as the original (whether using for graphing or any other mathematical use).īTW, you need to do the same thing in your scientific / graphing calculator to get an accurate graph or calculation that involves a log to a base other than 10 or e. So, log base 7 of x = log x / log 7 = ln x / ln 7 = Ln x means log base e of x (where e = 2.71. Log base b of a =(log base c of a) /(log base c of b). The idea is that (changing the base from b to c) you change the base but divide by the log (new base) of the old base. It (mine above) uses the change-of-base formula. Y = 3/2 times log x which is not the same as y = log (base 3/2) of x. If you don't understand get out an intermediate / college algebra or precalculus book. Anonomac, You're right, it is easy, but the object is to first get it right, then get it easy.

How to make a subscript in excel for mac graph axis