We saw in the two previous articles how to make Excel 2003 in a graph with two axes Y.
The big surprise, when trying to insert a graphic that is going to do with the command "All types of graphics," which is at the bottom of each family of graphs is that there over two-axis graph Y which is offered in Excel 2007, besides the two graphs very special position in the family "Fellow." Let us therefore
a simple histogram to represent the whole (see picture below). Of course, this is not satisfactory because we want to place the last series - Total - on an axis to the right and turn it into a curve.
No problem with that, there are two operations to be performed ...
First, right click on one of the four bars of the last series, then the command "Format a series data "and" Secondary Axis ". The series 'Total' is then represented by a thick histogram in the foreground.
then re-click Right then the "Change Chart Type Data Series" (which, among us, is a command name totally stupid! The last three words are too many ...) and select a curve.
that remains is to perfect representation, to both the red curve and the values of the right axis. We then get the desired result:
0 comments:
Post a Comment