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
jackdash

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
clunkfish

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

Windows 7 Home Premium
 
 

Thanks very much.

jack
My System SpecsSystem Spec
.

Reply

 Excel Line Chart




Thread Tools




Similar help and support threads
Thread Forum
cmd line way to mute line in realtek hd audio card
I have a line of music audio entering my realtek card to accompany a powerpoint slideshow, together they go out on our community cable channel. I need to kill the input, the music audio that is directly plugged into the card in the back of the pc, so that when I schedule a video (bod meeting...
Sound & Audio
Inserting a blank line in Windows 7 Excel
Finally got Windows 7 and when I started working on an excel spreadsheet, I found my tried and true Alt+I then R no longer works to insert a row. any idea if another letter will do it. After entering the R it moves me to the next tab. any help is appreciated. Thx. CB
Microsoft Office
Can I create a pie chart with data in an existing excel file?
Where I work an excel sheet with any and all "failed activities" (we're not getting paid) is sent out every wednesday. How can I highlight specific cells (for a specific person) and have that chart show how much of the failed activities belong to them. They obviously know that, but this will...
Microsoft Office
setting password - line 1, black dots : line 2, letters & numbers
When setting a password for user, when I type it, it shows up as black dots but when I retype the next line, it shows up as the letters, numbers and symbols that I'm typing. It won't let me set it. What the heck is going on? Thanks
General Discussion
Excel 2010 Chart Left Axis is in middle of chart
Hi, For some reason, the numbers for the left axis are in the middle of my chart and I have highlighted the axis and reformatted to no avail. How can I change the settings so it is shown on the far left as usual? I've uploaded a jpg showing the problem. A big thanks in advance,
Microsoft Office
Microsoft Excel 2010 - chart formatting question
Hello, I've just made a pretty decent scheme in my Excel. It's all good but I would like it to fill a whole A/4 sized piece of paper, by increasing the size of the cells as well as the text in them proportionally, so that I don't have any unused, blank cells. Is there a simple way to do this? ...
Microsoft Office


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 16:10.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App