ATOI365D

#Office365Challenge – Excel Column Charts. The next couple of posts will be all about the charts available in Excel. Today we’ll look at Column Charts.

Day: 102 of 365, 263 left
Tools: Excel
Description: Adding a column chart in Excel

To insert a chart you need data – of course. Data would be column headers with line items and data. Charts are available under the Insert Tab > Charts:
columnchart2

Click “inside” the data and go to the Insert Tab. Here select the column chart. You have various options:
ColumnChart1
columnchart
Columnchart3

columnchart4

Once the chart is inserted, the Chart Tools Tab will display, here you will have options under Design and Format to make changes to your chart. We’ll cover some of these in tomorrows post:

ColumnChart5

columnChart6

Catch you tomorrow for more on Bar Charts.

Overview of my challenge: As an absolute lover of all things Microsoft, I’ve decided to undertake the challenge, of writing a blog every single day, for the next 365 days. Crazy, I know. And I’ll try my best, but if I cannot find something good to say about Office 365 and the Tools it includes for 365 days, I’m changing my profession. So let’s write this epic tale of “Around the Office in 365 Days”. My ode to Microsoft Office 365.

Keep in mind that these tips and tricks do not only apply to Office 365 – but where applicable, to the overall Microsoft Office Suite and SharePoint.

Advertisements