Dividing excel chart into sections -
i want create typ of chart in excel:
with vertical gridlines dividing chart year, , labels each year. guy made chart said thinks drew in lines , added labels manually somehow. can done other way? drawing lines in charts isnt exact , other solutions i've found can't produce same result.
if have info looks like:
jan-14 4 feb-14 30 mar-14 56 apr-14 23 may-14 3 jun-14 62 jul-14 74 aug-14 12 sep-14 3 oct-14 15 nov-14 63 dec-14 74 jan-15 45 feb-15 3 mar-15 4 apr-15 56 may-15 23 jun-15 3 jul-15 62 aug-15 74 sep-15 12 oct-15 3 nov-15 15 dec-15 63 jan-16 74
you can select info , add together new scatter plot style chart. will, default, similar 1 above. vertical lines @ years, can right-click x-axis , take "format axis". click "fixed" "major unit" , come in 356 number.
right click 1 time again on x-axis , take "add major gridlines". should vertical line each year.
as boxes/labels years, may have manually or creative vba.
excel
No comments:
Post a Comment