chart autopopulation

Hello guys! How can I fix an issue in Excel where the percentage displayed on a bar chart is disproportionate to the actual value? This is my pivot table that contains the data. This is my graph where the light blue bar should be much smaller, considering the values of 2.56% and 2.05%...

Hi, Long time lurker first time question poster here :) I'm trying to plot a variable amount of series on a chart. I've created a dummy environment with data for my issue, however in the actual issues case, the data table in B29:R47 is filtered from a master on another sheet which I cannot...

I have charts fed from a table. The charts update automatically every time new data is entered like they should. My UCL and LCL calculations also are working. I am using a trend line chart. How do I add the UCL and LCL to the chart? Every example I find says to "paste special" in the chart...

Hi All. I have a table of data which I want to represent in a scatter chart. However, I would like to be able to set a flag against each row in the table to specify whether or not the point should actually appear on the chart or not. This way I can decide which are the pertinent data points to...

Hello Excel friends, I'd greatly appreciate help to learn how to do a couple of Excel tricks. The 'Data' sheet contains a single column A which houses the data in <Sheet1!B:B>. I'd like the chart to always display the x-most recent quarters of data, x being $C$2. If it's possible, I'd like $C$1...

I have an odd problem and was wondering if anyone has a better approach altogether vs. helping me fix my current approach. I have a robust excel and through a working macro: 1. I created 150 small charts and update their data 2. Creates multiple slides. This all works fine, but everytime I...

I am making a horizontal bar chart, showing projects under different categories over a 10 year time span. I was able to organize the data the way I need it, but am having issues with making the chart autopopulate. The chart data is being pulled from 'Sheet 3', which is a sheet that is...