Solved How to create a chart showing so many criterias?

December 9, 2016 at 22:39:13
Specs: Windows 64
This is the end result I am trying to achieve:

http://www80.zippyshare.com/v/EAdrK...

I have the data for average price change, the number of weeks, and the historical reliability. How do I plot them into one chart to show exactly the same?

Additionally, this chart is able to detect which week we are in, and highlight it as shown on week 49.

Thanks in advance.


See More: How to create a chart showing so many criterias?

Report •

#1
December 10, 2016 at 09:06:59
✔ Best Answer
I do not do charts very often, unfortunately.

How do I plot them into one chart to show exactly the same?

This should solve part of your problem. Look here:

https://blogs.office.com/2012/06/21...

It shows how to overlay 2 charts into one, but by repeating the process you can overlay multiple charts.

As for the second part,

chart is able to detect which week we are in, and highlight it as shown on week 49.

I'm not sure how it could be done.
Perhaps using Conditional Formatting to highlight the data,
but most likely you will need a Macro.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question