Afternoon all,
I'm having a bit of trouble figuring something out in Excel Pro 2010. Hopefully you guys can help.
I have data laid out in a table like this:
Day Metric A Metric B Metric C Mon 185 3.7 12,000 Tue 178 5.1 8,500 Wed 178 5.5 8,000 Thu 183 5.0 9,000 Fri 202 4.5 10,000 Sat 200 6.2 19,000 Sun 174 2.9 23,000
And I'm using the first three columns to create this basic bar/line combo:
barline.JPG
Simple enough! However, the data in the fourth column, "Metric C", let's me know how relevant the data in the other two columns are. The higher the number, the more confidence I have in the bar and line data points.
Is there a nice and friendly way to include that data in the chart above? I've been scratching my head, but I can't think of anything. I may be missing something really obvious that hopefully you guys pick up on.
Appreciate your help, as always.
Edit, just to clarify, Metric A is on the primary axis and Metric B is on the secondary axis. I'm out of axes!
Bookmarks