Excel Line Chart


  1. Posts : 168
    Windows 7 Home Premium
       #1

    Excel Line Chart


    I am trying to do a simple line chart using Excel in Office 2007.
    I have the dates in weekly order and two columns of prices, I want the chart to show the change in prices each week.
    I select these three columns then go to Insert and select the first line chart shown.
    It displays the price changes and the date format but by the month not the week.
    In there anyway to get this data displayed weekly?

    Thanks
    jack
      My Computer


  2. Posts : 295
    Windows 7 Enterprise x64
       #2

    Just highlight the time axis, then right-click and go to Format Axis...

    In the dialogue box, change Major unit: from Auto to Fixed, and set it to 7 days (see screenshot). That will give you a weekly chart :)
    Attached Thumbnails Attached Thumbnails Excel Line Chart-capture.jpg  
      My Computer


  3. Posts : 168
    Windows 7 Home Premium
    Thread Starter
       #3

    Thanks very much.

    jack
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd
All times are GMT -5. The time now is 08:29.
Find Us