+4 votes
79 views
How to Chart in Excel

in Office by (552k points)
reopened | 79 views

1 Answer

+5 votes
Best answer

How to make graphs in Excel

One of the most used applications for the subject of data management and spreadsheets, there is no doubt that it is Excellent, since this Office tool allows us to carry out a number of operations in a simple and fast way, applying its different formulas in depending on what we need..

 

 

Excel offers us a wide set of options to represent the data delivered or that we handle in a much clearer and more specific way and one of these ways is using graphics, a graph shows us a series of data in a single step allowing us to visually have Clarity about what projection you have, it is ideal in databases, statistics, sales, notes, etc.

 

Excel offers us various types of graphs to use but without a doubt one of the most used for its simplicity and representation and in TechnoWikis we will explain how to make graphs in Excel from the available data..

 

To stay up to date, remember to subscribe to our YouTube channel!
SUBSCRIBE ON YOUTUBE

 

 

How to make graphs in Excel

 

Step 1

We open Excel to see the data to be graphed:

 

image

 

Step 2

We select the range of cells to link to the Excel chart:

 

image

 

Step 3

It is possible from the Insert menu to select the desired type of graph but for a much simpler way, just press the Alt + F1 keys to directly open the graph in Excel with the selected data:

 

image

 

Step 4

There we can move the chart to the desired location within the spreadsheet:

 

image

 

step 5

As we can see, a new menu called "Graph design" is activated, in which it will be possible to manage both the appearance and the control of the graph data, from "Design styles" we select the style of the graph to use:

 

image

 

step 6

It will be applied automatically when the mouse passes over each design so that we are clear about what the style will be like, when clicking on a design it will be applied to the graphic:

 

image

 

step 7

From "Quick Layout" it is possible to modify the chart layout as needed:

 

image

 

step 8

We will see the design applied based on the options that Excel offers us:

 

image

 

step 9

We select the graph, in the "Graph design" menu in "Data" we click on "Change row/column" to change the order of the graph:

 

image

 

step 10

Based on the design applied to the graph, it is possible to change the title of the graph by clicking on it and adding the desired text for a better order of the data to work with:

 

image

 

step 11

We click outside the graphic to see the name of the applied graphic:

 

image

 

step 12

We double click on the graph to open a side menu with various options:

 

image

 

step 13

On the side, in the "Fill" section, it is possible to select one of the available options for the background of the graph, as well as solid colors and textures or gradients:

 

image

 

step 14

We activate the desired box to see the automatic change in the graph:

 

image

 

step 15

It is possible to copy our graph to other applications, in this case we right click on the graph and select the "Copy" option:

 

image

 

step 16

We paste the graphic in any desired editor, in this case Word:

 

image

 

In this way it is possible to create graphs in Excel from the available data and thus customize the result of these.

 


by (3.5m points)
edited

Related questions

+5 votes
1 answer
asked Jan 1, 2022 in Guides by backtothefuture (552k points) | 135 views
+4 votes
1 answer
asked Dec 23, 2021 in Guides by backtothefuture (552k points) | 95 views
+5 votes
1 answer
asked Nov 14, 2021 in Office by backtothefuture (552k points) | 87 views
+3 votes
1 answer
asked Dec 20, 2021 in Office by backtothefuture (552k points) | 106 views
+5 votes
1 answer
Sponsored articles cost $40 per post. You can contact us via Feedback

Most popular questions within the last 30 days

10,659 questions
10,791 answers
510 comments
3 users