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