Chapter_5_Charting_Tutorial - Right-click on the chart and...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 5: Excel Tutorial (Creating a Chart) After completing the tutorial, you will be able to create a chart within Excel. You will be able to edit a chart to show desired information in a number of different ways. Creating a Chart – the following steps can be used to create a column chart. You can create any number of different charts by following these steps, and selecting another kind of chart. 1) Open the Excel spreadsheet template. 2) Go to the Insert ribbon, and select the type of chart you would like to create. (Column 2D) 3) The chart will show up as blank, we now have to enter the series.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Right-click on the chart, and select Select Data… 4) Select the data associated with Deluxe VBC for Series 1. 5) You will now have to click on Edit to name this Volume-Based Costing. 6) Select Edit on the right hand side to select the labels for the bottom. (DM, DL, OH, Unit Cost) 7) Now select Add to select the data associated with Activity Based Costing and do steps 5 and 6 again. 8) Your Select Data Source should look like the one below: 9) Your final graph should look like the one shown below: 10) Now try to create the chart for the Regular Product....
View Full Document

This note was uploaded on 03/10/2012 for the course ACCOUNTING 5450 taught by Professor Brown during the Spring '12 term at Colorado Technical University.

Page1 / 3

Chapter_5_Charting_Tutorial - Right-click on the chart and...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online