Results 1 to 1 of 1

Thread: How do I make an Excel area chart display dates on the x-axis?

  1. #1

    How do I make an Excel area chart display dates on the x-axis?



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am compiling a chart that shows YouTube views growing over time. I created an area chart using the column of cumulative views. However, even when I set the first column to the "date" format, the graph keeps popping up with cell numbers instead of dates.

    If I click on "select data" I can list months manually for the horizontal axis, but then they don't line up properly with the graph.

    How can I get the x axis to read the first column as dates, and to list months for the tick marks?

    Thanks!

    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Excel help on YouTube views.png 
Views:	27 
Size:	44.2 KB 
ID:	3460  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •