Sometimes you would possibly wish to show 2 information series that disagree greatly in worth within the same bar-chart. If you utilize the default chart choice in excel you would possibly then get one thing like in (Figure 1) below.
This is after all undesirable since the information serial “(A) Productivity” isn’t even visible within the chart. Luckily in excel one is ready to show information on a secondary y axis. Simply choose information series “(B) Production”, and right click. Choose Format information Series, the Series choice and choose Plot series on select Secondary axis (Figure 2).
Now information series “(A) Productivity” is related to the first and series “(B) Production” with the secondary axis. The matter is that the bars within the chart are overlapping and part obscuring one another. This could be mounted by employing a work-around per the subsequent steps:
1). Choose the cell vary containing each of your information series (B1:C14 in our example) and drag and drop onto the chart. You may see one thing similar as in Figure 3. What we've got done is essentially adding 2 dummy information series to the chart. You may before long see why.
2). Now, choose any visible information series and cycle to “dummy” series “(A) Productivity” victimization the up arrow. Choose Format à elect information series à Axis tab à Plot series on à Secondary axis. You may currently see one thing almost like Figure 4.
3). Ok, we tend to currently have a chart with double information series, what now? Choose the primary series (green arrow in Figure 4) and right click. Select Format information series and within the Fill tab choose No fill and Border color choose No line. Choose the second dummy series (red arrow in Figure 4) and repeat the procedure to cover the bars (see Figure 5a & 5b).
4). You ought to currently have one thing almost like image half dozen wherever the information is planned on 2 axis and adjacent to every alternative rather than overlapping. Good luck!
-->[GenSMP]<--
No comments:
Post a Comment