Want the title of your chart to change based upon what is placed in a worksheet cell? It's easy; just add a formula to control the title. Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, and 2013. If you are using an earlier version (Excel 2003 or earlier), this. Open an Excel spreadsheet on your computer. Find the spreadsheet file you want to edit on your computer, and double-click on its icon to open the file. Alternatively, you can open the Microsoft Excel app, and open a sheet from your list of Recent files. ![]() In this article, Taryn (0ur seasoned blogger) has shown how to make Excel graphs/ charts look professional and cool. Outlook 2016 junk mail options. She has made her charts looks far far better using just 10 Excel charting tips. Let’s see how she has made her graphs look professional Creating charts and graphs is basically about ensuring effective visual communication and presentation of your data. Excel provides default graph settings, upon creation. However, for business purposes, it’s often necessary to spruce up a few elements of your chart, to ensure that you really wow your clients and/or boss with your amazing charts. Table of Contents • • • • • • • • • • • • • • • How to Make Excel Graphs Look Professional & Cool Here are a few handy tips for adding a professional flair to your graphs in Excel: 1. Make sure to add a descriptive title In the example below, the first graph has been updated from the default chart Excel provides, which is shown at the bottom. The first title provides better insight into the data, as well as the location/place it is drawn from. When contemplating titles, try and describe the source data the chart was based on and don’t forget to add the location/company or another place of reference if that information is available. A chart title is supposed to orientate the user and not leave the user trying to guess about who, what or where? Remember a chart is not supposed to be a puzzle. Remove all chart junk, clutter, and other distractions Gridlines are a common source of clutter. In the example below, the chart at the top has all the gridlines removed. The chart at the bottom has gridlines, which are not conveying any meaningful information. The data labels are already providing the numbers. In order to remove the gridlines, select one of them, but not the top one, though, then press delete. Read More: The other problem with the chart at the bottom is the vertical axis is cluttered and contains too many numbers that are not necessary. We can fix this by selecting the vertical axis by clicking on it. Right-click the axis once it’s selected and choose the Format Axis option. Expand the Axis Options section and change the major unit to 100, for the example below, and the minor unit to 20. Then expand the Tick Marks section and make sure for Major Type, Inside is selected. Another thing to consider about the vertical axis is that sometimes Excel sets the maximum, way beyond the actual data points. If this has happened to your chart, do not fear. Simply select the vertical axis then right-click and choose Format Axis. Office 2011 for mac high sierra plist. In the Format Axis panel, under Axis options, Bounds, set the maximum to a lower value. The chart at the bottom also contains an unnecessary zero. In the first chart, we removed this by again right-clicking the vertical axis, selecting Format Axis, in the Axis options section, expanding the Number section, in the Category section, we chose Custom, for format code type #” “, to clear the zero.
0 Comments
Leave a Reply. |