Saturday, 15 March 2014

Dividing excel chart into sections -



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