#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
I hope one of graphs in attachment will do!
|
#3
|
||||
|
||||
@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 |
#4
|
|||
|
|||
Thanks very much Arvi, that's exactly what I'm looking for.
Pecoflyer, you can use the one Arvi attached. Thanks both. |
#5
|
||||
|
||||
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 |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
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 |
conditional charting | omer123456 | Excel | 3 | 12-21-2011 12:53 PM |
Charting issue, please help! | powerpointnewbie | PowerPoint | 0 | 06-07-2011 03:04 PM |