Excel Chart for multiple variables


C

cqpinion

Hello,
I'm looking to plot this data ( i can manipuate the pivot to look different if needed)..

Interval A% B%
12/13/2014
07:00- 08:00 41% 0.5%
08:00- 09:00 87% 1.2%
09:00- 10:00 130% 1.5%
10:00- 11:00 166% 1.9%
11:00- 12:00 190% 2.1%

12/15/2014
07:00- 08:00 57% 0.3%
08:00- 09:00 94% 0.6%
09:00- 10:00 100% 0.6%
10:00- 11:00 180% 1.1%
11:00- 12:00 200% 1.3%

12/19/2014
07:00- 08:00 35% 0.3%
08:00- 09:00 80% 0.8%
09:00- 10:00 117% 1.1%
10:00- 11:00 155% 1.5%
11:00- 12:00 196% 1.7%

Basically, its hourly intervals per day, showing % for two different metrics. Ideally I'm thinking a line chart with two Y axes and interval on the X axis.

Any alternate view is acceptable as well, as long as it visualizes the relevant info in a clear way.

Thanks guys!

KJ
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top