If you have any comments or questions, please post them below. Below you will find the instructions on how to add a second axis to an Excel graph. The default for all your data sets is the Primary axis, you have the option of assigning your second data set to the second axis which makes your chart readable. In order to overcome this you can assign each data set an axis. When you put these together in a chart the monthly data is diminished by the much larger YTD values. A classic example of this would be your monthly data and your YTD values for each month. When using Excel and working with two data sets that differ greatly in range it can be difficult to chart those values due to the larger range of one of your data sets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |