C
C
Chichi2017-03-08 17:20:09
infographics
Chichi, 2017-03-08 17:20:09

How to visualize data (table with 4 options) in a chart using Excel?

In Excel I have a table with data. There are 4 parameters: Method , Lattice , Number of lines , Accuracy .
Table in Excel:
44903f73975a4a4d83323b184fd5df3d.jpg
This is data on recognition accuracy depending on 3 other parameters: method, grid type and number of lines.

  • The Method has two options: Distance and Number of Points.
  • The Grid has two options: Grid and Circular.
  • The Number of Lines has three values: 3, 5 and 9.

Different combinations of these 3 characteristics give different values ​​of recognition accuracy (last column).
I should present this data in a more demonstrative way and reflect it on a graph. Is it possible to visualize this data on a chart in Excel so that all 4 parameters are involved and reflected in the graph?
I use Microsoft Office Professional Plus 2016.
Uploaded an Excel file to DropBox: 4parameters.xlsx

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
shushpanio, 2017-03-09
@ChicoId

I propose the following:
1. finalize the table by correcting:
a) Convert the accuracy from numbers to percentages;
b) Write the word "Grid" in the same way in all fields. (in the attached file "Grid" is found in 2 ways of writing)
2. Make a pivot table and a pivot chart for it.
See screenshot for an example.
c959e71335e44a45a9a8625f927f4656.jpg

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question