I'm also aware that I can use the scientific notation, but they don't look good too. The chart becomes ugly for large y values. The Scientific format displays a number in exponential notation, replacing part of the number with E+n, in which E (exponent) multiplies the preceding number by 10 to the nth power. For example, a 2-decimal scientific format displays 12345678901 as 1.23E+10, which is 1.23 times 10 to the 10th power. [SOLVED] scientific notation to display 1.8 x 10-5 in Excel [SOLVED] Help There doesn't appear to be a format code for this sort of scientific notation. Convert scientific notation to text with Format Cells function. Let's take a look. Right click the desired axis, choose axis formatting. Is the power notation (10 n) possible for the y-axis on Excel charts? Equations created with Math (I used an equation I created in Write) can be copied and pasted into Excel Cells or Graphs. Scientific notation is a compact way to display values in the same column, even when they vary greatly in size. Plotting Data with Microsoft Excel [S & E web pages] Here is an example of an attempt to plot parametric data in a scientifically meaningful way, using Microsoft Excel. I also demonstrate how to add a line of best fit or "trendline" to the data and how to … If you have a lot of numbers which are displayed as the scientific notation, and you are tired of entering them repeatedly with the above method, you can convert them with the Format Cells function in Excel.. 1. In this video I explain how to make a simple scatter plot in Microsoft Excel. In column C of our table we have a … This example describes an experience using the Office X version for Macintosh. I have a Macbook with Excel 2011. For example, instead of displaying the y-axis ticks as 10 0, 10 1, 10 2, ... etc, Excel uses 1, 10, 100, ... etc. Then go to “options for axis” in the sidemenu on the right. Can Excel display scientiic notation as, say 3.00 x 10-12 as opposed to the number 3.00E-12? They can't be pasted into the title element itself, but it can be pasted to the graph, they appear in the upper left hand … The obvious code would be a "^" instead of an e. This doesn't work. Excel Scientific manufactures a variety of sealing films and foils specially designed for many common microplate applications. There's a workaround that might help.