Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2019, 05:06 PM
gib65 gib65 is offline help charting a graph Windows 10 help charting a graph Office 2003
Advanced Beginner
help charting a graph
 
Join Date: Aug 2010
Posts: 72
gib65 is on a distinguished road
Default help charting a graph

Hello,

I tried to produce an Excel graph. It looks like this:



This is not what I want.

I would like the rating to show up on the Y axis (ranging from 3 to -3) and the date to show up on the X axis. Then I would like a line graph joining the points. For example, on Nov 18, there should be a point at -1, and on Nov 19, there should be a point at -2, and there should be a line joining them. Then there should be a point at -1 on Nov 24th, and a line joining the -2 on the 19th to the -1 on the 24th, and so on.



If someone could explain to me how to do this, I would very much appreciate it.
Reply With Quote
  #2  
Old 02-04-2019, 12:31 AM
ArviLaanemets ArviLaanemets is offline help charting a graph Windows 8 help charting a graph Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

I hope one of graphs in attachment will do!
Attached Files
File Type: xlsx GraphExample.xlsx (17.2 KB, 11 views)
Reply With Quote
  #3  
Old 02-04-2019, 12:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now help charting a graph Windows 7 64bit help charting a graph Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

@gib65
Posting a sample sheet would make things easier for everyone. Pictures are nice to look at but useless to work with
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #4  
Old 02-04-2019, 07:32 PM
gib65 gib65 is offline help charting a graph Windows 10 help charting a graph Office 2003
Advanced Beginner
help charting a graph
 
Join Date: Aug 2010
Posts: 72
gib65 is on a distinguished road
Default

Quote:
Originally Posted by ArviLaanemets View Post
I hope one of graphs in attachment will do!
Thanks very much Arvi, that's exactly what I'm looking for.

Pecoflyer, you can use the one Arvi attached.

Thanks both.
Reply With Quote
  #5  
Old 02-05-2019, 12:31 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is online now help charting a graph Windows 7 64bit help charting a graph Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Yes I can
nonetheless, in the future please post a sheet as requested and mark the thread as solved if you are happy with the answers
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
help charting a graph column clustered bar graph with a line graph as secondary axis Alaska1 Excel 2 06-09-2014 07:13 PM
Priority of line graph vs bar graph in terms of front to back positioning on a chart DavePPointuser PowerPoint 1 04-30-2014 10:57 AM
Excel Charting ubns Excel 0 05-10-2012 05:55 PM
help charting a graph conditional charting omer123456 Excel 3 12-21-2011 12:53 PM
Charting issue, please help! powerpointnewbie PowerPoint 0 06-07-2011 03:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:46 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft