+ Reply to Thread
Results 1 to 4 of 4

Limits bar chart

  1. #1
    Registered User
    Join Date
    06-21-2021
    Location
    Vilnius,Lithuania
    MS-Off Ver
    2020
    Posts
    2

    Limits bar chart

    Hello, I am trying to visualize received results from the analysis and would like to create a limits bar chart to display them. The idea of the chart is to have minimum and maximum limits on the right and left side respectively visualized with straight lines and then add minimum and maximum values that were calculated inside those limits to see if they are within limits or not. Could not find a straight forward solution how to make that within excel chart. In the attached graphs you could see an example what I would like to receive as an output. Another figure illustrates values that should be used to implement that. Min and max temperature displays results. Other two columns displays lower and upper limits.

    Thank you in advance for your advises!
    Attached Images Attached Images

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,138

    Re: Limits bar chart

    It is difficult for me to understand exactly what you are having trouble with.

    What I see in your picture is a spreadsheet with a bunch of temperature data and some in-cell charting. At the bottom is a chart that looks like a stacked bar chart or maybe a stacked bar + XY scatter combination chart. I do not see in the spreadsheet part of the picture any of the data that appears to be needed for creating the chart, so I'm not sure where or how you are getting the bottom chart from the data in the spreadsheet part of the picture.

    Are you familiar with how to create a stacked bar chart? How are you obtaining and where are you storing the data that the stacked bar chart needs? Creating the stacked bar chart should be straightforward once you have the data for the chart somewhere in the spreadsheet. The main thing I am not understanding is how you get from the data in the picture to the data that the chart needs.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    06-21-2021
    Location
    Vilnius,Lithuania
    MS-Off Ver
    2020
    Posts
    2

    Re: Limits bar chart

    Dear MrShortly,

    Thank you for your response. One of the attached pictures is not from the excel. The idea is to use data with results (numbers) and create similar charts where each row would represent one line. Please see attached one more example that I made with other software. Ideally, I would like to create a chart with such information: 1 - Lower limit (Min) 4- Upper limit (Max) 2- Min. temperature 3-Max.temperature.

    I am not familiar at the moment how to create chart like this in the excel. I will review the information that you sent me. If you could provide any useful examples I would be really grateful.

    Thank you in advance and hope you understand my explanations.
    Attached Images Attached Images

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    16,138

    Re: Limits bar chart

    If you are unfamiliar with creating stacked bar charts in Excel, this tutorial should help: https://www.extendoffice.com/documen...umn-chart.html Their example is even for a two category multiple "stacks" type of chart, so it should be particularly relevant to the latest picture.

+ 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. VBA chart limits
    By Stevo56 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-02-2015, 01:14 PM
  2. Creating Pivot chart threshold limits
    By MasterElaichi in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-30-2014, 09:26 PM
  3. Line Chart data point limits
    By randinator in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-13-2014, 11:17 AM
  4. Stacked Column Chart showing the Limits
    By rose4emi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-12-2012, 04:15 AM
  5. Many specification limits in one control chart (?)
    By atabac in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 08-07-2010, 05:26 PM
  6. How to plot pie chart(s) with click of button and set limits?
    By jieyi in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-15-2009, 06:04 PM
  7. Help setting scale limits on chart
    By Jerome Ranch in forum Excel General
    Replies: 2
    Last Post: 07-01-2006, 06:55 AM

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