chart type

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...

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!!!

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...

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.

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...

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?

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...