As we know that Charts of graphs are the graphical representation of a tabular data. Charts are very easy to analyze as it is a scientifically proven fact that visual data is more easily to understand and interpret.
Excel is a super tool and provide us so many type of charts within seconds. We can create a chart by just selecting the data and clicking a button, which makes it really very easy to create.
But even then there are a few situations which become difficult to handle. For tackling such situations we need to use different tools available in Excel and make the things work. In this article, we are going to handle one such situation.
Have you ever tried to put the TEXT LABELS on the vertical axis??
Yes, in the clustered bar chart, it can be done easily but what about the others. Suppose we want to create a Line chart , where the labels are on the vertical or y axis. It is not easy to create Labels on the vertical axis.
So, in this article, we will create a graph showing a line chart and the labels on the vertical axis.
Let us try to plan our solution.
We have to create a chart with categories on the vertical axis and line chart on the horizontal axis.
In a single chart, it won’t be easy to create such chart, as it is not available. As soon as we choose the Line chart, it’ll
create a chart of course, but put the labels on the horizontal axis itself.
So, it derives that we need to create a combo chart. The first chart will be CLUSTERED BAR as it’ll help us to get the labels on the
vertical label and second will be XY Scatter chart as It is the only chart which allows the repetition of the values, as X,Y values
can repeat at different levels.
So let us try to build our chart.
We’ll take the following example.
We want to find out the number of frequencies of failures of a machine in the different years. [ It is just an example ]
The following table shows the data.
|YEAR||NUMBER OF FAILURES|
We’ll create a vertical line chart in Excel for this data.
Follow the steps to create one.
|YEAR||TEMP||NUMBER OF FAILURES|
After our table is ready, let us start the process.
The data of main series that is THE NUMBER OF FAILURES need to be edited for the data.
Follow the steps.
After clicking the EDIT BUTTON, the following dialog box will open.
Look at the chart above.
The XY chart shows the correct values in the way we want.
Now we are just left with a few tasks.
Bring the text labels to the left side.
Remove the extra elements present on the chart.
After changing the STYLE of the chart we get the final output as follows.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE