Solved

Excel 2010 Sparklines - horizontal bar

Posted on 2016-10-12
2
60 Views
Last Modified: 2016-10-19
I'm trying to get a Sparkline like in the attached image.
Sparkline I'm trying to get
The Sparklines options don't seem to have horizontal bars. It should be possible then with Conditional Formatting? If so, how?

Thanks
0
Comment
Question by:hindersaliva
2 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 41841175
You're better off creating a tiny bar chart based on the data, like so:
EE-horizontalsparkline.png
Once you have one set up, you should be able to make duplicates for additional rows.  See the example file.

Regards,
-Glenn
EE-28975987.xlsx
0
 

Author Comment

by:hindersaliva
ID: 41849866
Thanks Glenn. It helped a lot.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
TT ADD Formula 2 10
TT Need Bit Change in logic 6 11
MIN, using ARRAY 4 16
Macro Filter fix 3 5
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now