How realize a graphic on a table in Excel 2010

Many of us have had the opportunity to see at least once a Graphic Presentation in various fields: the evolution of the exchange rate, election results, statistics, etc. The most popular program is charting Excel. The values ​​of a spreadsheet in a graph according to lines si columns for the reporting. In the following we will briefly introduce how to realize a simple graphic.

Excel Table

The first step to do is to compose a table based on results according to at least 2 references. Table must contain cells with numerical values: numbers, dates, percentages, depending on the category to ask wish to relate.

Format Cells in Excel

 cell format is achieved by selecting fields with valuesand choosing the tab Home attributes for these cells: General, Number, Currency, Accounting, Date, etc. After we defined data fields table, numbers, percentages, etc., choose the columns then do reporting and chart by selecting them with mouseAnd in the tab Insert,section Charts, Choose the type of graphic that we want to achieve for the selected field.

Charts in Excel

Here we have a lot of graphics options from column representations of various shapes, colors and sizes, line graphs connected by points, graphics disk type, horizontal bar graphs, charts form surfaces, graphs with points or ring all provide the opportunity to illustrate the evolution of image values ​​according to at least 2 references. For greatest impact can be made in variations charts 2D or 3D for each of the options above.

Insert Charts in Excel

We choose a chart type column in which I used 3 references: date, number of visitors and number of visits.

Charts in Excel Tools

After creating the schedule of option Charts Tools We can customize chart and other information about the table represented by this graph, we attach schedule table in the basement of the option Data TableWe can customize Legend, display reference axes, reference lines and other features that can improve the quality of the graphic presentation.

After completing this schedule may be inserted into a presentation or can be printed on the sheet of paper or foil for a presentation.

How realize a graphic on a table in Excel 2010

About the author

Stealth

Passionate about everything that means gadgets and IT, I write with pleasure stealthsettings.com from 2006 and I like to discover with you new things about computers and operating systems macOS, Linux, Windows, iOS and Android.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment is processed.