Go Premium for a chance to win a PS4. Enter to Win

x
Solved

# Excel 2010 sparklines with min/max ratio

Posted on 2013-12-03
Medium Priority
405 Views
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.
0

LVL 85

Accepted Solution

Rory Archibald earned 1500 total points
ID: 39691898
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

LVL 4

Expert Comment

ID: 39691904
Can post some example here?
0

Author Closing Comment

ID: 39692067
many thanks :)
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
###### Suggested Courses
Course of the Month8 days, 19 hours left to enroll