C
C
Chichi2017-03-28 19:56:09
infographics
Chichi, 2017-03-28 19:56:09

How to remove merging by category on the x-axis in a MS Excel chart?

There is a table with data in Excel. There is also a chart based on this data.
Spreadsheet in Excel:
3d722f57cd194c8b8830eacfe82991ef.jpg
Different combination of 4 neural networks gives different Accuracy results. Each neural network has its own characteristics (they are indicated as numbers separated by a hyphen).
For clarity: The combination of 4 neural networks with different characteristics: [34-3-20], [68-3-20], [102-3-20], [128-3-20] gave an accuracy of 74.29% etc.
The chart looks like:
e4ee0d06eb7641ea88df0480731d5224.jpg
In Excel, if a network with the same characteristics was used in combinations, then a union was performed on the chart. I wanted for each accuracy result below (along the X axis) to show all the neural networks that gave such a result (even if they are repeated, they still show again). But by default, Excel did the merge. I would also like to avoid the word " blank " in the diagram.
For example, for an accuracy of 74.29% below in the diagram, I wanted 4 neural networks to be specified: [34-3-20], [68-3-20], [102-3-20], [128-3 -20]
For an accuracy of 85.71% , below in the diagram I wanted 3 neural networks to be indicated: [68-3-20], [102-3-20], [128-3-20]
Question:is it possible somehow in the settings of the Excel chart to make it so that the chart along the X axis does not have a union according to the used neural networks in combinations? And is it possible to somehow get rid of " blank "?
Uploaded Excel file to DropBox: Excelchart[SO].xlsx

Answer the question

In order to leave comments, you need to log in

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

And is it possible to somehow get rid of "blank"?

put a space in empty cells

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question