chart type

  1. A

    Pivot chart type changes anytime the table is changed

    Hi, I have a pivot chart linked to a pivot table. In the chart, I superimpose two types of charts, a bar chart (on the primary axis) and a line chart (on the secondary axis). Anytime any filter of the columns of the pivot table is changed, the chart type changes to all bar chart and I lose the...
  2. J

    Prevent slicer from changing chart type

    Hi there, I have a pivot chart in excel with a few different slicers. My problem is that when I click on some of the slicer options, it changes my chart type (I had a chart with bars as well as a line graph). How can I keep the slicer from changing the chart types? Thank you!!!
  3. C

    Combining Two Graphs and Representing Each in different styles

    Hello, I have a Workbook with two Sheets containing a xy scatter plot each. Each graph contains about 30 data series and about 1000 points in total. I know that I can copy/paste one graph area onto the other to do a direct comparison. However when I do this, it standardises all the data...
  4. J

    Inner / Outer Circular Chart Type

    Can anyone please assist me in creating a chart like the image below? I'm not talking about a doughnut or a stacked doughnut but rather the following: Thanks in advance for the assistance.
  5. R

    Employee Schedule not plotting properly - chart type / data series not correct

    Hello, Attached is my spreadsheet (SHIFT_COMPARE) which is supposed to plot the work hours that employees are scheduled to work vs the day they are working, on a weekly basis. It consists of 3 worksheets: "Const", "Sched", & "Chart". "Const" = a "back end" sheet containing constants & raw...
  6. B

    When to use a horizontal bar chart or vertical?

    As the title suggests - I'm wondering when is best practice to use vertical bars versus horizontal? I can only think that when you have long category names then they are better off horizontal, so a horizontal bar chart is better. But are there any hard and fast rules I should follow?
  7. T

    Bar Chart: some series stacked, others not. Problem with overlaping

    Hi, I got a problem building a bar chart. I have 3 series and I want 2 of them to be stacked and one not to be stacked. I´m plotting the single series in secondary axis and in clustered bar chart" type, the other two are on primary axis an are a stacked chart type. My problem is that í cant...

Watch MrExcel Video

This Week's Hot Topics

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
Top