stacked chart

  1. B

    Suppress zeroes in stacked chart

    I have four categories across multiple series of data. Let's call them Red, Blue, Green, Yellow. I have a stacked chart showing the numbers of data points in each category. The chart has labels showing the value of each point, centred in each colour. However, sometimes there is none of a...
  2. A

    Stacked waterfall graph problems

    Hi All, I am trying to adjust a waterfall/bridge graph that is used to analyse operating profit year on year. The graph is illustrating the change in operating profit by Business units. Within one Business unit there has been a £1.5m growth and a £1.7m loss within a new branch unique to...
  3. L

    stacked chart percentage

    Heey guys, Does anyone have some experience on the problem below? I am having the following problems when trying to create a stacked chart. I would like to make adjustment in the chart below. Since I would like to make a similar chart with different data. For this example, assume the y-axis...
  4. R

    Help with stacked bar chart

    Hello! Ive encountered a problem i have no idea how to solve. Ill write whole story: We had a practical assignment with water pumps. We took the power consumed by pumps like 240W for example and measured the height of hose 1-7 meters. So the power consumption changes when the hose gets higher...
  5. M

    Seeking advice for monthly P&L reporting across various brands

    Hi everyone, I'm not too good with Excel and I would greatly appreciate your help with this project. I receive monthly P&L reports from 4 brands . Within each brand, there are 2-3 stores. These P&L reports are individual excel files. My aim is to consolidate all the P&L reports into a single...
  6. J

    Private equity chart help!

    Hi guys, I need to create a chart that is often used in private equity valuation. Like this one: The basis for it is a clustered stacked chart, which I have figured out to do. However there are two additional features I am unable to implement. 1) I would like to connect the top of the first...
  7. R

    Variable Column width with stacked columns

    <tbody> Income Next 3 months 4-12m 13-24m aa 100 bb 100 cc 100 dd 200 ee 300 ff 400 gg 500 hh 600 ii 200 jj 100 kk 200 ll 200 mm 100 nn 50 oo 50 pp 50 </tbody>
  8. R

    Stacked Column chart with percentage line

    I am trying to create a chart that has the primary axis as a stacked chart that shows 2 figures (numbers of sales & number of referrals). I am then adding a line that shows percentage across the chart in a secondary axis. The issue is that I need this line to show the percentage of sales that...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top