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