clustered

  1. JackDanIce

    Clustered column chart - highlight specific column if condition met

    Hi, I have: A time line from A1:A10 (months) Revenue data: B1:B10 (+ve values) Cost of Revenue: C1:C10 (+ve values) Difference: D1:D10 with formula =ABS(C1-B1)<1000 I currently use A1:C10 to show a clustered column table comparing Revenue vs Cost of Revenue over time I've been asked to...
  2. I

    Clustered bar chart

    I have clustered bar chart. I have one array of values where the values can go from -5 to 5. The y-axis is a 0 which is good but the y-axis labels are also in the 0 range.Since the axis value is positive or negative, some bars actually overwrite that y-axis labels. If I move the axis to one...
  3. M

    Any way to create a clustered column type view in a Pivot Table?

    Hi all, I'm building a kind of dashboard using a couple of Pivot Charts and a few slicers linked to the underlying Pivot Tables. I want to recreate a clustered column chart as a Pivot Chart to have it updated by the slicer. It shows the person and how many documents they created, and how many...
  4. P

    Clustered Range Bar Chart

    Hi there, is there any way/tricks to make data chart like this (idk what's it called.. maybe Clustered Range Bar Chart?). Thank you in advance..
  5. mooseman

    Excel Clustered Column chart data labels positioning

    <tbody> I have a clustered column chart with volume and %change data. I want the %change labels to always be just above the x-axes, even if they are negative. The %change is on the secondary axes. </tbody>
  6. J

    Clustered Stacked Bar Chart with Line Series Overlay (so close...)

    [/URL][/IMG] I am trying to create a graph which contains a clustered bar chart with two lines overlayed (series names "Budget" and "Forecast"). Using guides from this site, I was able to create a clustered bar graph, but the lines are trickier. For some reason, only the markers for each data...
  7. D

    Chart - Clustered with Secondary Axis

    [/IMG] Hi, I need to create a combo clustered chart for the above but I'm having trouble getting it to display correctly. Primary axis - cull values -24 & -30 side by side - death values -23 & -25 side by side Secondary axis - cull values -4.1% & -8.0% side by side - death values -3.9% &...
  8. A

    Excel Graph and Error Bar overlapping on top of columns

    Good afternoon I have a bar chart with YoY performance. I wanted to highlight certain area's by using a vertical line that works with the data. When using an Error Bar it places the line in between the 2016 and 2017 clustered columns when I want it to appear before or after the clustered...
  9. S

    Excel charts: Displaying multiple data series as columns SEQUENTIALLY

    Dear excelers, I am having trouble trying to create the following chart: I have frequency data for medications used by participants in a clinical trial (i.e. how many times a particular drug is taken by study participants). The medications are divided into subcategories of drug classes. For...
  10. D

    VBA coloring columns in chart

    i have several clustered column charts that i'm struggling to color them in a specific way so, the default Excel colors look something like that: http://i.imgur.com/rBL3vBi.jpg what i want is this: http://i.imgur.com/rAZDzGv.jpg the table is this (ploted by columns in the macro)...
  11. 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...
  12. R

    Cluster & Stacked Bar Chart

    Does anyone know how to do a 3D bar chart that is both clustered and stacked like in this picture. http://www.nevron.com/gallery/FullGalleries/chart/bar/images/XYZ_Stack_Bars_Chart.png
  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...

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