+ Reply to Thread
Results 1 to 9 of 9

Figure in bar chart

  1. #1
    Registered User
    Join Date
    01-27-2023
    Location
    Mechelen
    MS-Off Ver
    Office 365
    Posts
    7

    Figure in bar chart

    I've created a bar chart that automatically adjusts when the data in the table changes.
    Now I would like to place a small figure in each bar, which of course follows the bar when it moves to a different position. The figure may be in or just in front of the bar. The bars are horizontal, although that won't be important. The figure may not fill the bar, because then it will change when the bar will be greater.
    Thanks in advance
    Jos
    Attached Files Attached Files
    Last edited by Jos1403; 01-28-2023 at 04:48 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Figure in bar chart

    Try to attach, please a sample file similar with thae situation you face it
    Diana Tanase


    If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !

  3. #3
    Registered User
    Join Date
    01-27-2023
    Location
    Mechelen
    MS-Off Ver
    Office 365
    Posts
    7

    Re: Figure in bar chart

    I hope the attachement clearly.
    I have made a tabla where you can put numbers. The total is made automaticly!
    Than I have sorted them automaticly from the higest until the lowest.
    I have made 2 examples of tables.
    The first with 2 stables. In the orange part I will put a figure in it. But it has to stay allways there with the same size.
    In the second example the figure has to stay on thr right size and allways with the same size.
    Is something like this even pssible??

    PS: Sorry for my bad English!

  4. #4
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Figure in bar chart

    When you say figure, did you mean the value associated in the table with each chart bar?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    01-27-2023
    Location
    Mechelen
    MS-Off Ver
    Office 365
    Posts
    7

    Re: Figure in bar chart

    Yes, in every bar a different figure. But each figure has to be the same size (every time) No matter how great the bars are....
    Last edited by Jos1403; 01-28-2023 at 06:43 PM.

  6. #6
    Valued Forum Contributor
    Join Date
    06-23-2021
    Location
    Romania
    MS-Off Ver
    2021, 365 v 2208
    Posts
    722

    Re: Figure in bar chart

    Like in file attached in post#4?

  7. #7
    Registered User
    Join Date
    01-27-2023
    Location
    Mechelen
    MS-Off Ver
    Office 365
    Posts
    7

    Re: Figure in bar chart

    Yes.
    For example: fill in de table with some numbers.
    You will see then that de bar chart will change, even put them on another place (depend on the total). So far, so good!

    But:
    Example 1: I can put a figure in the orange bar, but in my example the figure will change from dimense (if the blue bar becomes larges for example) and won't stay at the same stable. So, that is my problem that I can't solve...
    Example 2: the figure will fill the hole (blue) bar...

    I hope you can see an example....
    Attached Images Attached Images
    Last edited by Jos1403; 01-29-2023 at 03:41 AM.

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

    Re: Figure in bar chart

    I changed the second bar series to xy-scatter.

    To add the rocket copy a shape, select the xy-scatter series and paste.
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

  9. #9
    Registered User
    Join Date
    01-27-2023
    Location
    Mechelen
    MS-Off Ver
    Office 365
    Posts
    7

    Re: Figure in bar chart

    Thank you very much!!! That was exactly wat I needed!!!!

+ 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. Point and Figure Chart
    By dhrugupta in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 06-01-2020, 02:30 PM
  2. [SOLVED] I cant figure out how to fix my line chart
    By A10ECGENT in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-04-2014, 11:10 AM
  3. Replies: 4
    Last Post: 02-03-2014, 08:05 AM
  4. How do I autopopulate last figure in Chart
    By DanielBarker in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-28-2013, 05:09 AM
  5. Cant figure out how they made this Chart
    By mithu81 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-29-2009, 05:17 AM
  6. Newbie... can't figure out this chart
    By Turner in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-29-2007, 09:01 AM
  7. How do you get a chart to show no figure and not a zero
    By kosciosco in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-26-2005, 11:40 AM

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