How to Edit an Excel Chart

Edit Excel Chart thumb

So, you have inserted a chart in your document?

But now you would like to format the graph professionally?

Great! In this article, we’ll teach you how to do that step-by-step.

Let’s suppose that this is the chart you have added.

This is the initial chart you've added

Throughout the years Microsoft have made some great improvements in the way Excel charts look and feel when initially inserted. However, this doesn’t mean that you shouldn’t be able to format your charts and that there’s no room for improvement from the default settings.

All right. Let’s see how we can format this graph professionally.

I prefer to have my charts in Arial – that is why I’ll right-click over the chart and select its font to be Arial.

Setting Arial as the chart font

My favourite font size is 8. Don’t worry, it isn’t too small.

Setting the chart font size

 Let’s do another right-click, but this time select “Format Chart Area.”

Formatting chart area

Here, I’d like to remove the fill of the chart and its border-line. Click “No” for both.

Removing the fill of the chart and its border-line

The next step will be to render the gridlines less invasive. Let’s select the gridlines and do a right-mouse click in order to select “Format Gridlines.” I’ll choose to have a solid line, which is gray and is transparent at 75 percent. I think gridlines look much better this way.

Adjusting the formatting of the chart gridlines

Let’s adjust the size of the chart, as we want to have a quarter-page chart.

Adjusting the size of the chart

We’ll need to select a label for the horizontal axis. I’ll just click on the chart, choose “Select Data,” go to the “Horizontal Axis Title” section within the dialog box which opens and select the three years under analysis, as we have the breakdown of revenues for each of these years in the three columns. Let’s change the colors of the chart a little bit. Usually, I prefer changing the default colors of Excel charts.

“Net Sales” will be in dark blue.

Adjusting the colors of the chart

Now, let’s make the columns of our chart a bit larger. In order to do this I’ll make a right-click on one of the columns and select “Format Data Series.”

Here is the option for formatting the data series

Once I am in the “Format Data Series” menu, I’ll reduce the size of the “Gap Width” from 150 percent to 50 percent. OK.

Formatting the data series and axis

The default labels are in black, but probably the better option is to have them in white and in bold. 

Changing the formatting of the default labels

Let’s format the axis a little bit, shall we?

Formatting the axis of the chart

I’ll adjust the minimum and maximum dimensions, so that our chart shows the data in a better way.

Adjusting the minimum and maximum dimensions of the chart

And here is our modified chart. Pretty neat, right?

Here is the final modified chart

Financial Auditing: Ultimate Guide

Financial auditing entails producing an opinion on the truth and fairness of the financial statements of a company. Only

Financial Auditing: Ultimate Guide

Financial auditing entails producing an opinion on the truth and fairness of the financial statements of a company. Only licensed accounting professionals (auditors) authorized by the relevant governing bodies for the territories they operate in can carry out the auditing of financial statements. Audits were first regulated with the...
Learn More

Clearinghouses and Custodians: Financial Intermediaries 101

Intermediaries are vital for a well-functioning financial system and allow their clients to solve the problems they face more

Clearinghouses and Custodians: Financial Intermediaries 101

Intermediaries are vital for a well-functioning financial system and allow their clients to solve the problems they face more efficiently than they could by themselves. We find several types: Brokers, Exchanges, and Alternative trading systems Dealers and Securitizers Depository Institutions Insurance Companies Arbitrageurs, and Clearinghouses and Custodians We shall...
Learn More

Long and Short Positions: Guide to Wall Street Lingo

Rather than an instance of duration, long and short positions are a reference to haves and have-nots. They touch

Long and Short Positions: Guide to Wall Street Lingo

Rather than an instance of duration, long and short positions are a reference to haves and have-nots. They touch on securities an investor really owns versus securities an investor owes. Basically, the terms “short” and “long” denote what “selling” and “buying” do respectively. Featured: What is a Long Position?...
Learn More