+ Reply to Thread
Results 1 to 8 of 8

Pictograph that changes color/picture once a value is given

  1. #1
    Registered User
    Join Date
    03-15-2018
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    6

    Pictograph that changes color/picture once a value is given

    Hi I'm fairly new here and I want to ask for help regarding the use of Pictographs in excel. Currently I have a basic knowledge on making basic pictographs in excel here is what I am trying to do:

    data 1|:
    the cool emoji would represent the target say 5

    if say out of the 5 target data. 2 have already been accomplished the pictograph would then look like this which is represented by the smile emoji

    data 1|

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Pictograph that changes color/picture once a value is given

    something like this?

    =REPT("C",A2)&REPT("J",B2-A2) Windings formatted

    if you want another/different pictures/colors you'll need VBA or/and embedded icons in the workbook
    Attached Files Attached Files
    Last edited by sandy666; 03-15-2018 at 09:38 PM.

  3. #3
    Registered User
    Join Date
    03-15-2018
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    6

    Re: Pictograph that changes color/picture once a value is given

    I was planning on making use of the Bar graph and converting it to a pictograph like the other tutorials but this will do. But I would still be open on any help on how to do it in the chart function of the excel.

    Thanks for your help kind person

  4. #4
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Pictograph that changes color/picture once a value is given

    Like this one?

    or show example in excel file
    Attached Files Attached Files
    Last edited by sandy666; 03-15-2018 at 10:31 PM.

  5. #5
    Registered User
    Join Date
    03-15-2018
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    6

    Re: Pictograph that changes color/picture once a value is given

    yes sir like that one. but i am having a problem with controlling the value of each picture. in this case, I want one picture to be equal to "1"

    Sorry, I would like to post what I have did based on your pictograph, but I am not yet allowed to post links and attachments

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: Pictograph that changes color/picture once a value is given

    Maybe you'll find more: Peltier
    or you can try stack and scale graph and play with horizontal axis maximum
    Attached Files Attached Files
    Last edited by sandy666; 03-17-2018 at 12:34 AM.

  7. #7
    Registered User
    Join Date
    03-15-2018
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    6

    Re: Pictograph that changes color/picture once a value is given

    Thanks mate. It is exactly what I am looking for

  8. #8
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Pictograph that changes color/picture once a value is given

    You are welcome

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

+ 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] Conditional format of color of picture
    By InvGrp2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-18-2015, 09:41 PM
  2. [SOLVED] Get Pixel Color of Picture Overlaying Cells
    By TheSpriceEffect in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-03-2014, 12:25 PM
  3. [SOLVED] Change color in a picture using a color palette.
    By MariaPap in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2014, 02:45 AM
  4. Click on picture and run macro to replace existing picture with selected picture file
    By houseflipsheet in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-14-2014, 12:02 AM
  5. Read picture-pixel color ?
    By onidarbe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-10-2009, 05:10 PM
  6. Replies: 0
    Last Post: 06-27-2006, 11:30 AM
  7. How do I create a pictograph in Excel?
    By ldimes4 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-08-2006, 01:35 PM

Tags for this Thread

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