Solved

Excel 2013 line charts

I need to create a line chart in excel 2013 with 183 dates along the bottom axis. After 100 dates it will only show every other date. Is it possible to show all dates. I've tried changing axis to 1 day but this does not work after 100 dates.
2 answers Last reply Best Answer
More about excel 2013 line charts
  1. Best answer
    Probably, there's just not enough physical space on that axis for 183 dates. Make your chart extremely wide, and check whether the axis labels are displayed the way you want them.
  2. Alabalcho said:
    Probably, there's just not enough physical space on that axis for 183 dates. Make your chart extremely wide, and check whether the axis labels are displayed the way you want them.


    Many Thanks for taking the time to reply you were correct abut there being insufficient space. Much appreciated
Ask a new question

Read More

Apps Excel Axis