Question

QUESTION 19 In a complete paragraph, describe how to build a graph. List how many quadrants are present and the values of X and Y in each quadrant T T T 쫓 Paragraph . Arial . 3 (12p0 . ·T. Of. +Mashups . 삠 “ ⓒ @ ふ囲" Hilm.UU :HHXU 1101

Answer 1

1.Enter your data into Excel.
2.Decide upon one of nine graph and chart choices to make.
3.Highlight your data and 'Insert' your preferred graph.
Four.Change the info on every axis, if essential.
5.Adjust your knowledge's design and colors.
6.Alternate the size of your chart's legend and axis labels.
7.Trade the Y axis measurement choices, if preferred.
Eight.Reorder your information, if desired.
9.Title your graph.

1. Enter your knowledge into Excel.

First, you need to input your data into Excel. You would have exported the data from in different places, like a section of advertising and marketing software or a survey instrument. Or maybe you're inputting it manually.

Within the instance under, in Column A, i've a record of responses to the query, Did inbound marketing show ROI, and in Columns B,C, and D, i have the responses to the question, Does your organization have a formal sales-advertising and marketing contract?For example, Column C, Row 2 illustrates that forty nine% of folks who have an SLA (service stage contract) also say that inbound marketing demonstrated ROI.

2. Decide on one of nine graph and chart options to create.

In Excel, you have a lot of selections for charts and graphs to create. This includes column (or bar) graphs, line graphs, pie graphs, scatter plot, and more.

3. Highlight your information and 'Insert' your favored graph.

The data i'm working with will seem satisfactory in a bar graph, so let's make that one. To make a bar graph, spotlight the data and incorporate the titles of the X and Y axis. Then, go to the 'Insert' tab, and in the charts part, click on the column icon. Decide upon the graph you desire from the dropdown window that appears.

On this illustration, I picked the first 2-dimensional column alternative -- simply in view that I prefer the flat bar graphic over the 3-D appear. See the resulting bar graph below.

4. Change the information on each axis, if critical.

If you wish to switch what seems on the X and Y axis, proper-click on the bar graph, click 'pick information,' and click on 'switch Row/Column.' this will likely rearrange which axes carry which pieces of data in the record proven beneath. When you're completed, click on 'good enough' on the backside.

5. Regulate your data's design and colours.

To alter the design of the labeling and legend, click on the bar graph, then click on the 'Chart Design' tab. Right here, which you could decide on which design you decide upon for the chart title, axis titles, and legend. In my illustration (proven beneath), I clicked on the alternative that displayed softer bar colors and legends under the chart.

To additional structure the legend, click on on it to disclose the 'format Legend' sidebar, as proven under. Here, that you could trade the fill color of the legend, if you want to in flip exchange the colour of the columns themselves. To format other elements of your chart, click on on them in my view to reveal a corresponding layout window.

6. Trade the scale of your chart's legend and axis labels.

While you first make a graph in Excel, the size of your axis and legend labels might be a little bit small, relying on the form of graph or chart you pick (bar, pie, line, and many others.). As soon as you may have created your chart, you can need to reinforce those labels so they're legible.

To develop the scale of your graph's labels, click on on them in my opinion and, as a substitute of revealing a new structure window, click again into the 'house' tab in the high navigation bar of Excel. Then, use the font style and measurement dropdown fields to develop or curb your chart's legend and axis labels to your liking.

7. Trade the Y axis measurement choices, if desired.

To vary the kind of measurement shown on the Y axis, click on the Y axis percentages on your chart to disclose the 'format Axis' window. Right here, that you would be able to decide if you want to show units placed on the Axis choices tab, or if you wish to alternate whether the Y axis shows percentages to 2 decimal locations or to 0 decimal places.

Considering that my graph routinely set the Y axis's maximum percent to 60%, I might wish to alternate it manually to one hundred% to represent my data on a extra common scale. To do so, i will be able to opt for the 'highest' alternative -- two fields down under 'Bounds' in the layout Axis window -- and alter the value from 0.6 to 1.

The resulting graph would be modified to look like the one below (I expanded the font dimension of the Y axis via the 'house' tab, so you can see the difference):

8. Reorder your data, if favored.

To form the data so the respondents' answers show up in reverse order, correct-click on your graph and click on 'choose data' to reveal the identical choices window you known as up in Step three above. This time, click on the up and down arrows, as shown beneath, to reverse the order of your knowledge on the chart.

If in case you have more than two traces of data to adjust, that you may additionally rearrange them in ascending or descending order. To try this, highlight all of your data in the cells above your chart, click 'information,' and choose 'type,' as shown below. That you could select to sort centered on smallest to biggest or greatest to smallest, depending for your preference.

9. Title your graph.

Now comes the enjoyable and handy part: naming your graph. By way of now, you might have already discovered how to try this. This is a simple clarifier.

Right after making your chart, the title that appears is frequently "Chart Title," or anything similar relying on the version of Excel you are utilizing. To vary this label, click on on "Chart Title" to disclose a typing cursor. Which you can then freely customise your chart's title.