Excel 2010 sparklines with min/max ratio

When using sparklines with various columns and rows of data, how can I get a sparkline for the ratio of all data?

Each row has a sparkline, but that is only relevant to the range in that row. How can I get sparklines, that compare to the other data, so that each sparkline is relevant to the next and not just to that range of data in the one row.
broadcastwarehouseAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Rory ArchibaldConnect With a Mentor Commented:
Can you be more specific? You can set the Value axes for the sparklines to be consistent across the rows, if that's what you mean? On the Sparkline Design tab click the Axis dropdown and set the Minimum and Maximum to be the same for all sparklines.
0
 
andrew_manCommented:
Can post some example here?
0
 
broadcastwarehouseAuthor Commented:
many thanks :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.