Make sure there are no tick marks beside the minimum and maximum so that Excel does not do auto-scaling. For my short-term goal, this value was 70000. In the maximum box, enter your goal target. In the Scale tab, manually enter a 0 in the minimum box. Double click the vertical axix to bring up the Format Axis box. In the Options tab, enter a 0 in the Gap Width box. Double click the column in the chart to bring up the Format Data Series box. In the Chart Wizard – Step 3 of 4 – Chart Options box that displays, make the following changes: 1) Titles: Enter a title for your chart, 2) Axes: Deselect Category axis, 3) Legend: Deselect Show Legend. Don’t chnage anything in the Data Range or Series tabs – just Click Next again.Ħ. In the Chart Wizzard box, select Column as the chart type and Clustered Column as the chart sub-type. Select cell B4 and click the Chart Wizard button.Ĥ. In addition, be sure to leave column C blank as well.ģ. Be sure to leave row 3 blank – there must be an empty cell between rows 2 and 3. Set up column A, B, and C just as it is displayed below. Open up Microsoft Excel and create a new spreadsheetĢ. The steps below are for Excel since that is what the majority of people use as a spreadsheet program.ġ. I am using Apple Numbers to create these charts so yours will look a little bit different. Here are the two charts I created to track each of my goals. It was very easy to set up and have outlined the steps below to do this yourself. To see how I am tracking to these goals I have created a nifty little Microsoft Excel chart that shows presents me with a cool vidual representation of where I am at in relation to each goal. I have two portfolio goals I have set for myself – one is a short-term goal (link) and the other is a long-term (link) goal. I am a visual type of guy and like to see things in either hard print or digital data right in front of me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |