• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2071
  • Last Modified:

Excel 2010 Sparklines - horizontal bar

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
hindersaliva
Asked:
hindersaliva
1 Solution
 
Glenn RayExcel VBA DeveloperCommented:
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
 
hindersalivaAuthor Commented:
Thanks Glenn. It helped a lot.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now