+ Reply to Thread
Results 1 to 5 of 5

2 Sparklines in a single cell in excel?

  1. #1
    Registered User
    Join Date
    04-06-2012
    Location
    India
    MS-Off Ver
    Pro Plus 2019
    Posts
    86

    2 Sparklines in a single cell in excel?

    Hi!

    I have data in 2 columns as follows:

    Col. A Col. B
    10 15
    10 14
    10 15
    6 13
    12 5
    14 8
    10 10
    13 6
    9 14
    10 9

    Data in Col. A is converted as a line sparkline and data in Col. B is viewed as a Column sparkline.

    I wish to view both the sparklines superimposed on each other in the same cell using excel's native sparkline option (not a third party software).
    Is it possible using some sort of Excel wizardry/ workaround?

    PS: I need 2 actual sparklines in the same cell, not a Sparkline superimposed on a chart reduced to the size of a cell.

    Sample file attached

    Thanks,
    Naira

    NOTE: This question was posted at Ozgrid forum at http://www.ozgrid.com/forum/showthre...074#post703074 However, since no working solution given there, hence posted on this forum.
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,249

    Re: 2 Sparklines in a single cell in excel?

    Don't think you can mix sparkline types in a single cell.

    Best work around would be a linked picture of the sparkline positioned over the spark columns.

    Why not use a chartobject?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-06-2012
    Location
    India
    MS-Off Ver
    Pro Plus 2019
    Posts
    86

    Re: 2 Sparklines in a single cell in excel?

    Quote Originally Posted by Andy Pope View Post
    Don't think you can mix sparkline types in a single cell.

    Best work around would be a linked picture of the sparkline positioned over the spark columns.

    Why not use a chartobject?
    Hi Andy,

    Thank you for your reply.

    1. Cannot use Chart object since I am using about 1200 sparklines in a workbook that is being updated in Real time every second. 1200 charts being updated in realtime would crash my workbook

    2. Can you please post a workbook example about how to use a linked picture of sparkline positioned over the spark columns? Will this linked picture of Sparkline be updated in realtime (with data in the same workbook)

    Thanx

  4. #4
    Registered User
    Join Date
    04-06-2012
    Location
    India
    MS-Off Ver
    Pro Plus 2019
    Posts
    86

    Re: 2 Sparklines in a single cell in excel?

    Found a tutorial about linked picture sparklines at http://alesandrab.wordpress.com/2013...ble-sparklines

    Any views on what is less memory intensive? Linked pictures or Excel charts?

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,249

    Re: 2 Sparklines in a single cell in excel?

    I would not use linked pictures if you have 1200 sparklines to map to.

    Your only other approach would be to draw the sparklines yourself with shapes.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to subtract single cells with double digits into a single digit of a single cell.
    By greenfox74 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-11-2021, 02:05 AM
  2. Sparklines (Excel 2010)
    By ElmerS in forum Excel General
    Replies: 3
    Last Post: 09-05-2013, 04:46 AM
  3. [SOLVED] Sparklines messed up by formulas returning a blank cell
    By jankee in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-01-2013, 07:30 AM
  4. Sparklines in Excel
    By sgriggins3 in forum Excel General
    Replies: 1
    Last Post: 06-12-2012, 05:46 PM
  5. Replies: 1
    Last Post: 04-16-2011, 09:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1