Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Excel Line Chart

28 Apr 2010   #1

Windows 7 Home Premium
 
 
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 System SpecsSystem Spec
.

28 Apr 2010   #2

Windows 7 Enterprise x64
 
 

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
Excel Line Chart-capture.jpg  
My System SpecsSystem Spec
29 Apr 2010   #3

Windows 7 Home Premium
 
 

Thanks very much.

jack
My System SpecsSystem Spec
.


Reply

 Excel Line Chart




Thread Tools




Our Sites

Site Links

About Us

Find 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 07:47 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33