![]() Excel Design Tricks for Sprucing Up Ugly Charts and Graphs in Microsoft Excel 1) Pick the right. If you're using another version or operating system, implementing the following tips may look different. ![]() Type "mmm" without quotes in the Format Code section and click "Add." Doing so labels the data using only units of months. Below are some quick tips for how to use Excel to make your graphs convincing, easy-to-read, and beautiful. You can also select a bar or line chart.Ĭlick the "Format" tab, select the "Chart Area" drop-down menu from the Current Selection group, choose "Horizontal (Category) Axis" and click "Format Selection."Ĭlick the "Axis Options" arrow to expand the section and select "Date Axis."Ĭlick the "Base" drop-down menu and select "Months." The graph then uses months, but the labels use specific and potentially inaccurate dates.Ĭlick "Number" to expand the section, click the "Category" drop-down menu and choose "Custom." ![]() If no neighboring data exists, simple click any data point to have Excel automatically recognize the entire data set.Ĭlick the "Insert" tab, select "Insert Column Chart" from the Chart group and choose your preferred format. Click the top left data point, hold the "Shift" key and click the bottom right data point to select all data.
0 Comments
Leave a Reply. |