lkpbutler.blogg.se

You can place labels at the outside start, and other options in that list. The Y axis crosses the X at the far right, aka at the end. Here's what it looks like (in the next screen shot) with End selected. You can have the axis cross at the start, the end, or a particular category. Now you have various settings in the Positioning tab. Be sure the axis is selected, then right-click on the axis and choose Object Properties. Double-click the chart, then click on an axis, I'm showing the Y axis first.

You can modify where the axes intersect and where the labels are. Inserting a normal bar chart you get the data below. You can now control where the axes intersect each other. Make the appropriate settings and click OK. should they be used as titles/headings/labels in the chart or are they actual data. You'll be prompted to say whether the first row and column are labels, i.e. Select the cells and drag them onto the chart. If you just want to change the data a chart is based on, you can drag. You can just look at it, or change it and click OK. If you don't see anything highlighted you can right-click on the chart and choose Data Ranges. The person who created it didn't have the courtesy to even use the headings of the data in the chart so you've got no info about what the info is.ĭouble-click the chart and you'll see, highlighted, the cells the chart is from. But what if there's a whole bunch of different data sets in the sheet if there are many sheets in the spreadsheet or if you just got a spreadsheet from someone who left the company to go teach yoga in Aruba and you have no idea what the spreadsheet is about? ).If you create your own chart, you can usually remember what data it came from. Your submission is to be a spreadsheet (.xls. Create a column "Town Abbreviation" of the abbreviation of each town, where an abbreviation is created using the first 3 letters of the name of a town. (d) (e) Create a row "Total" of the totals of each of the numerical columns. (c) Create a column "Viable" of the viability, either "yes" or "no", of each of the towns, where a town is viable if its population after 5 years, given by "5-yr Population", is at least 1.05 times (larger than) its (original) population. (b) Create a column "5-yr Population" of the forecast population of each of the towns after 5 years, where the population of each town grows (each year) at the rate given by "Growth Rate". Town Heresville Madderdrop Weilburg Duusterdorp Population Growth Rate (%) 749 0.06 1622 0.19 7143 2.24 3196 1.6 (a) Create a column "# of Representatives" of the number of (government) officials assigned to each town, where 1 representative is assigned to every 500 citizens (rounded) of a town.

Using Microsoft Excel, OpenOffice Calc or Google Sheets, create a spreadsheet using the data below and following steps.