stacked

  1. A

    Stacked + Clustered Bar Chart

    Hello, I want only one of my bars get stacked. I add additional data but it shows up only in the first bar. Let me explain with image: This orange stacked part must be on the top of bar of 2017. Any idea how to do this? File on image: https://we.tl/IcfmrCwobR Thank you
  2. B

    100% stacked bar chart + line chart

    Hello guys I'm trying to create a 100% stacked bar chart with a (line chart?) on top of it like this The main data is the columns A,B and C and then the there's the last column which is the average and I want to make it look like a line chart (the one in the orange line). can anyone help me...
  3. B

    100% stacked bar chart + line chart

    Hello guys I'm trying to create a 100% stacked bar chart with a (line chart?) on top of it like this The main data is the columns A,B and C and then the there's the last column which is the average and I want to make it look like a line chart (the one in the orange line). can anyone help me...
  4. C

    For the life of me can't figure out how to make the kind of bar chart I want

    I have a set of data -- emails sent per month for various users. So for example, in Nov-11 user "Bob" sent 3 emails. In Dec-14 "Bob" sent 25, "Susie" sent 15, "Michael" sent 5, and "Barbara" sent 10. I would like to have a chart that shows this, with the months being on the x-axis. I would...
  5. J

    Checbox stacking and form size - Excel Bug?

    I have experienced an issue with "disappering" checkboxes from cells, very much like described in the link attached. Positioning of form controls using VBA code – Bug in Excel 2010? | Excel Ticker The issue accures when filtering rows and saving the worksheet. On reopening of the worksheet...
  6. P

    PowerView - Stacked Column Chart - change colours

    Hi, I've used PowerPivot to get some data out of an Oracle warehouse, the data includes a total number, and then a target for the week and a cumulative target for the week so far. I've then created several if statements in new columns to determine whether the total has met either the cumulative...
  7. H

    Skip Zero or N/A values on clustered and stacked bar chart?

    Hi everyone. I'm trying to produce a clustered and stacked (or stacked and clustered depending on your phrasing) bar chart. The rows in my data can have multiple values spanning across multiple columns, but not all row/column intersections will have values (and at certain times, rows will have...
  8. G

    Bar chart help needed!

    I would like to create a chart that looks like this: http://img406.imageshack.us/img406/6536/visualizationchallenge.gif How do I do it?
  9. D

    Trouble with a Dynamic Clustered Stacked Column Graph in Excel 2007

    Hi All, I'm looking for some help with a dynamic clustered stacked column graph. I've been using the fantastic guide provided by Jon Peltier http://peltiertech.com/WordPress/clu...mn-bar-charts/ which has gotten me 1/2 way to my goal, but I can't get the chart to work dynamically (it's missing...
  10. J

    Macro Copy and paste 3 sheets with same layout in another sheet stacked

    Hi, I need to consolidate 3 sheets in a workbook into one sheet in same workbook. The data from the 3 sheets need to be stacked underneath each other. Extra rows may be added in the future, so the macro need to copy the entire range of data. The macro should Not loop through the whole...
  11. N

    Stacked Bar Chart Help

    Trying to create a stacked bar chart with multiple series and am not sure how to lay out my data. Keep getting Series 1 that contains data from all three. Right now I have my data like follows <tbody> Control No Variance High Impact Low Impact GSA Additonal ATP PS-1 8 2 2 3 PS-2 4 1 2 0...
  12. T

    Pivot Table Column Filtering

    Hello, I am trying to create a stacked column chart that will show for each name, the amount of times a specific code shows up ex data. Name Code Joe -----123 Bill ------345 Sarah----123 Bill ------123 Joe------345 and the graph would show 3 column with joe's and bill's haveing a second...
  13. F

    Advanced - Customized Chart

    Hi, I need to create a chart which have two columns, as xlCylinderColClustered, but one of the columns must be as xlCylinderColStacked, can someone please help me? I have tried even with some macross, but i guess in excel 2010 this kind of charts can't be combined into one single chart, am I...
  14. T

    Gantt or stacked bar chart timeline - help needed!

    Hi there,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm attempting to chart data obtained from our phone system to see when users are logged in/on rest. <o:p></o:p> <o:p></o:p> I’m using Excel 2007.<o:p></o:p> <o:p></o:p> The data we...
  15. F

    Stacked Area Graph

    I am trying to plot a series of regions ("passes") that represent a polygon. All regions are defined by a set of X and Y data that define their border. Each polygon region is a continuum...i.e. although on polygon one there is a y-value of 0 at x=8.0 and a y-value of 0.35 at x=7.25, it is...
  16. M

    Panel Charts, Small Multiples, Trellis, Stacked or????

    Ok so I am knee deep in a charting project and hoping that someone here can clear up something for me through answering a question below. So I am familiar with a feature back in the day when I was heavy on SharePoint and MS Office Web Components webpart (awesome and I hear a better version is...
  17. B

    Stacked bar graph

    Hi, I have an issue, that may have been discussed on this board before, but I haven't been able to locate any discussions on. Essentially I have the following data set 2007 2008 XX YY XX YY cat 1 74 3,681 79 3,806 cat 2 565 2,835 597 2,886 cat 3 987 98,658 1,044...
  18. I

    Inverted / Mirrored Bar Chart

    Hi, I am fairly new to Excel and would like to create an inverted or mirrored stacked bar chart. I have 5 people and I want to show their beginning sales opportunity for 4 different products at the beginning of our quarter and want to show how much they sold at the end of the quarter. A sample...

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