what type of chart is this?
http://www.advisorperspectives.com/d...since-2007.gifSample Chart to Duplicate.pdf
Can anyone tell me what type of chart this is? I have to duplicate it with data that is currently in a different type of chart....the existing chart has an x axis as a bar chart and a secondary axis as a line chart, and a trend line on the x axis data. I'm unclear how to get that data to look like the attached sample.
Any help is greatly appreciated.
Thanks!
xy-scatter with 2 series. 1 for the dots and 1 for the line.
shaded area can be done with another series as area or columns
Thank you Andy Pope! I've attached the same chart as a scatter - looks funny...is this correct? Should the x asis be the scatter line and then the y axis be a scatter with only markers?
Thank you Andy Pope! I've attached the same chart as a scatter - looks funny...is this correct? Should the x asis be the scatter line and then the y axis be a scatter with only markers?Sample Chart New.xlsx
Your x axis data is not a true date, which is why the horizontal axis reads zero to 14.
Your 2 sets of data are in different units ($ and %), unlike the example picture you posted.
finally the trend line in the picture is a moving average where as you have a linear one.
Thank you again Andy, very helpful!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks