+ Reply to Thread
Results 1 to 6 of 6

How 2 make different shapes on histograms?

  1. #1
    Registered User
    Join Date
    05-12-2020
    Location
    Hertzelya Israel
    MS-Off Ver
    16
    Posts
    23

    How 2 make different shapes on histograms?

    Hello Everyone,
    I have an excel histogram chart, and I'm looking to make it in 2 forms:
    For example stripes for one type of data and ordinary for other type of data.
    Someone knows how to do that?

  2. #2
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    164

    Re: How 2 make different shapes on histograms?

    HI
    I do not understand.
    Could you be so kind as to attach an example of what you have and what you would like to obtain, perhaps handmade.
    HI,
    Mario

  3. #3
    Registered User
    Join Date
    05-12-2020
    Location
    Hertzelya Israel
    MS-Off Ver
    16
    Posts
    23

    Re: How 2 make different shapes on histograms?

    histograms.jpg
    For example at the attachment:
    I want some of the histograms to be stripes, and some remain smooth.
    How can I do that?

    Thanks

  4. #4
    Forum Contributor
    Join Date
    09-03-2016
    Location
    Catania, Italy
    MS-Off Ver
    Excel 2019
    Posts
    164

    Re: How 2 make different shapes on histograms?

    HI
    I think it can only be done with VBA.
    This is the code:
    in This_WorkBook
    Please Login or Register  to view this content.
    and this in a Standard Module
    Please Login or Register  to view this content.
    Try changing the value in cell B2 of the attached file.
    Let know. HI,
    Mario
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-12-2020
    Location
    Hertzelya Israel
    MS-Off Ver
    16
    Posts
    23

    Re: How 2 make different shapes on histograms?

    Hi,
    Thank you very much for the help.
    But is there another way to do this except VBA? I'm asking this because I'm not familiar with VBA.

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,829

    Re: How 2 make different shapes on histograms?

    The standard approach to getting different formatting in charts is to have different data series for each desired format. Technique explained here: https://peltiertech.com/conditional-...-excel-charts/ Note that most of the work is in the spreadsheet, dividing the data up by which ones you want to be smooth and which ones you want to be striped.

    Will something like that work for you?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Make shapes appear and hide according to value in cell
    By James Steady in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-04-2020, 12:04 PM
  2. Making VBA Macro to make shapes disappear if cell has certain value (Multiple Shapes)
    By Nicholaes in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2019, 06:33 PM
  3. VBA to make all selected shapes transparent in PPT
    By dgibney in forum PowerPoint Programing
    Replies: 3
    Last Post: 09-20-2017, 03:43 AM
  4. Replies: 5
    Last Post: 08-11-2017, 03:05 PM
  5. excel 2013 customize context shapes and shapes group menu right click
    By Giuseppe77 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-03-2016, 11:50 AM
  6. Make Shapes non-resizeabe and not moveable
    By DeyAgahi in forum Excel General
    Replies: 2
    Last Post: 07-08-2013, 02:23 AM
  7. How To Move Shapes From Another Shapes? (floating shapes)
    By MarcLev in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2009, 04:04 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