chart autopopulation

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