![]() ![]() 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |