dynamic chart

I am trying to have a excel chart that would be controled by a scollbar and combobox I have an existing chart with dynamic ranges so for example dataSetA is defined as <code style="margin: 0px; padding: 0px; border: 0px; font-size: 13.63636302947998px; vertical-align: baseline; font-family...

I have a personnel resourcing workbook that is used by a number of different departments. Each department is only interested in their own view of the data. Only a couple of senior managers care about global views of the data. I have created a chart linked to a cell with a List data validation...

I am trying to create some dynamic charts through the use of named ranges and the concatenate formula with some data validation lists to select which data to graph. So using the SERIES() function I am able to plot the data if I type in my named range directly into the formula (ex: Hours!AbCd)...

Hi All. I trying to make a chart in Excel grow dynamically based on a couple of user inputs. I have data from 24 months, but I want to be able to choose how many of these month to show, and which month should be the first month in the chart. I have followed this guide Chart the Last 12...

Hello Everyone, I'm trying to write a module that selects a data range for my chart worksheet and changes the title, subtitle, a textbox, and axis labels dependant on button clicks. I have sub routines that select which named range to use based on button clicks and set some of my global...

Is there a way to have a graph automatically show the data from two days ago, as in, it will change everyday to show the data from two days before. Also Need one to show the last 7 days for another data range, same updating as first one. I know a macro could do this, but I am slammed at work...

Using: Microsoft Excel 2010 I have run into a pesky little problem when charting a set of data that I need to sort multiple times. I have a set of clinical patient data, that resembles the data below. I need to chart Test 1 Results, but separate charts for different groups of patients. For...

Hi Guys, Ok so I need to create a dynamic chart that only portrays the last 12 sets of data. The data goes along like this and continue with the dates and weeks <colgroup><col><col><col><col span="2"></colgroup><tbody> 05/01/2013 12/01/2013 19/01/2013 26/01/2013 1 2 3 4 Ashley 27.01%...

I'm running an office. In order to see where I've been and where I'm going I keep track of things like new patient visits, patient report visits, cash in, insurance in, etc. I keep track of this on a daily basis on one worksheet. The weekly totals are paste-linked into another sheet. It is this...

Hi there, So I'm trying to create a chart that updates itself dynamically and displays the last 7 weeks worth of data prior to the current date. I watched a handy tutorial online about creating named ranges out of the OFFSET functions that relate to the specific data column entries and have...

Hello! After looking a video in Youtube, I have been able to use the OFFSET function in excel 2010 to make a dynamic chart. I plot a X Y (Scatter) chart, and I use a cell to tell it from which row on should be plotted. It works perfect, but the axes values don't get properly updated. There is a...

Hey everyone, this is my first post! I've figured out how to create a dynamic chart, where the last values of my data are forced to be blank using an IF formula. The range that I created for which this works has the following formula...

Hi guys, I am trying to make a dynamic chart (line graph) that updates to include additional columns as they are added. I have found tutorials on how to make a dynamic chart that updates each time data is added under the same headers, but can't figure out how to make one that updates to include...

Hi, I want to make my charts dynamic and can only find explanations of how to do it using data from the chart in column format. i.e. the data goes down from A1:B4. My data goes across the rows. i.e. from A1:D2 How to use defined names to automatically update a chart range in Excel Microsoft...

Hi All, Excel 2007 I'm preparing quite a complex weekly report and so I'm making use of dynamic charts based on a number of named ranges. Is there anyway to avoid having to create a named range for each and every series? This is proving somewhat tedious with certain types of chart, such as...

I want to create a chart that is automatically updated, both when a new row or column is added to the spreadsheet. I created a name for my dynamic range, using =OFFSET(Top!$B$4, 1, 0, COUNTA(B:B)-2, COUNTA(5:5)-1)] <tbody> a b c d e g 1 2 3 4 Top Customers...

I developed dynamic chart with use of the offset formula. The data range in a chart is expressed like that:='time series profiler.xlsx'!income_y After saving and closing file the formula alters itself and looks like that:=[0]!income_y Obviously, at this stage the chart loses the dynamic...

Hey guys, I've never created a chart using VBA but have no found the need to do so. It's a bit of a sticky question. I need a chart with one series being a bar chart on the primary vertical axis and the other series being a line graph on the secondary vertical axis. The series length can...

I need to create a chart from data on multiple pages of a worksheet. This is for a long-term summary of standardized test results for a school. The workbook is set up with all the results for a particular year on each sheet, with at least 12 sheets for past years. Students will not necessarily...

Hi All, I'm making a dynamic chart with code I found online (peltiertech.com), it was a post from 2009 so I hope you can help: Sub ClickSeriesCheckbox() Dim rCell As Range For Each rCell In ActiveSheet.Range("TrueFalseRange").Cells rCell.EntireColumn.Hidden = Not rCell.Value Next End...