How To Make Excel Graphs Look Professional?

How to Make Your Excel Line Chart Look Better

  1. Remove Chartjunk – gridlines, chart border, and legend.
  2. Use Soft Gray Lines for the Axes.
  3. Make the Line Wider.
  4. Use a Non-Default Line Color.
  5. Add an Appropriate Title.
  6. Add Data Labels.
  7. IF Specific Data Points are More Important: Emphasize the Line’s Data Points.

Contents

How do I make my chart look professional?

The 5 steps to a professional looking chart

  1. Get rid of the legend. Most charts have only one data series, so the chart title gives you all the information you need.
  2. Change the gridline colour to light grey. Double-click on one of the gridlines to open the Format Window.
  3. Make the bars wider.
  4. Add Data Labels.

How do I create an impressive chart in Excel?

10 Simple Tips To Make Your Excel Charts Sexier

  1. Remove Noise From Your Chart’s Background.
  2. Move The Legend.
  3. Delete Legends With One Data Series.
  4. Add A Descriptive Title.
  5. Sort Your Data Before Charting.
  6. Don’t Make People Head Tilt.
  7. Clean Up Your Axes.
  8. Explore Other Themes.

How do you make a chart more visually appealing?

Then choose the chart most appropriate for your data.

  1. 2) Sort bar graph data so it’s intuitive.
  2. 3) Shorten Y-axis labels.
  3. 4) Remove background lines.
  4. 5) Remove default line margins.
  5. 7) Stay away from 3D effects.
  6. 8) Delete the legend if it’s not necessary.
  7. 9) Include branded colors.
  8. 10) Add a shaded area to a line chart.

What makes the chart more attractive and meaningful?

°IF Specific Data Points are More Important: Emphasize the Line’s Data Points.°IF the Overall Trend is More Important: Emphasize the Line Trend.

How do I create a beautiful dashboard in Excel?

Here’s a step-by-step Excel dashboard tutorial:

  1. How to Bring Data into Excel. Before creating dashboards in Excel, you need to import the data into Excel.
  2. Set Up Your Excel Dashboard File.
  3. Create a Table with Raw Data.
  4. Analyze the Data.
  5. Build the Dashboard.
  6. Customize with Macros, Color, and More.

How do I make my bar chart more attractive?

12 Design Tips for Awesome Bar Charts

  1. Arrange data intuitively. The point of a chart is to make data easier to read.
  2. Watch your bar widths.
  3. Don’t use 3-D.
  4. Use the proper direction.
  5. Use consistent colors.
  6. Keep y-axis labels short.
  7. Ditch the grid.
  8. Don’t forget a title and source line.

How do you make impressive graphs?

Five principles of good graphs

  1. Show the data clearly. Showing the data clearly includes ensuring the data points can be seen but also providing meaningful text on the graph itself.
  2. Use simplicity in design of the graph.
  3. Use alignment on a common scale.
  4. Keep the visual encoding transparent.
  5. Use standard forms that work.

How do you make a graph more aesthetic?

Gradient colors make charts more aesthetic when compared with solid colors. You can use gradient colors to enrich your chart’s appearance and to convey some additional information. In the following screenshot, gradient color is applied by replacing the solid color just to elevate the appearance.

Why are the bars in my Excel chart so skinny?

The bars of a Bar Chart will become skinny like this when the category axis is set to a “Continuous” axis mode. To get the bars to become thicker, just set the axis mode to “Categorical” here: Bar Chart Properties > Categorical Axis > Columns: Settings > Axis mode: Categorical.

How can I make my dashboard more attractive?

How to design and build a great dashboard

  1. Be clear about what you’re trying to achieve.
  2. Include only the most important content.
  3. Use size and position to show hierarchy.
  4. Give your numbers context.
  5. Group your related metrics.
  6. Be consistent.
  7. Use clear labels your audience will understand.
  8. Round your numbers.

How do I create a dynamic chart in Excel?

To do so, simply select the data range and do the following:

  1. Click the Insert tab.
  2. In the Tables group, click Table.
  3. Excel will display the selected range, which you can change.
  4. Click OK and Excel will format the data range as a table.

What should all good graphs have?

Graphs should always have at minimum a caption, axes and scales, symbols, and a data field. Plotting symbols need to be distinct, legible, and provide good contrast between the figure in the foreground and the background.

What are the 3 things a graph must have?

Essential Elements of Good Graphs:

  • A title which describes the experiment.
  • The graph should fill the space allotted for the graph.
  • Each axis should be labeled with the quantity being measured and the units of measurement.
  • Each data point should be plotted in the proper position.
  • A line of best fit.

What are the 5 things a graph needs?

There are five things about graph that need our attention when designing graphs:

  • visual structures,
  • axes and background,
  • scales and tick marks,
  • grid lines,
  • text.

How do I thicken a bar graph in Excel?

Click on any bar in the Bar Chart and right click on it, then select Format Data Series from the right-clicking menu. See screenshot: 2. In the popping up Format Data Series pane, move the Zoom bar of the Gap Width to the left side until the bar width meets your needs under the Series Options section.

How do you make a column graph thicker?

Larger bars
The solution for this is to click the Excel chart’s X axis, right click and choose Format Axis. Select Axis Options and then click on Text Axis to select it. This changes the way the axis is plotted giving wider bars. You can then adjust the gap width if necessary to make them wider.

How do I make my sheets thicker in bars?

Here are the steps.

  1. Right-click on any column inside your chart.
  2. Select ‘Format data series’.
  3. Drag the slider under the ‘Gap width’ to the right to make the columns thinner and to the left to make the columns wider.