dynamic graph

Dear Friends, I have added following Excel file for you to understand my problem. There is a picklist that you can choose first week and last week. According to this choices of the user, I want my graph to be changed dynamically. My dates are week that I manually wrote as text format. Therefore...

Is there a tool in Excel 2016 that allows you to create a dynamic graph? By that I mean you write out a few parameters at the top of a spreadsheet and the graph goes and gets the data where it needs it from elsewhere in your sheet and updates itself. My guess is this process will have to be...

I have a simple line graph of a column of data, something like: =Table!$C$1:$D$1500. However, the data is added to regularly, so the upper limit needs to be dynamic (lower limit is fixed at C1). I can use the COUNT function to calculate the upper limit, but have no idea how to use it for a...

Hello everyone, I would kindly like to ask you for a help. I would like to create a dynamic graph. Once I do that, all data is in, but all x-axis names/labels do not appear. Anyone, who could help me, please? Thank you very much in advance! Regards Luboš H.

I want to create a scattered plot graph with data that will change depending on a selection of a list. I already have the dynamic range in a cell, but I can't seem to use the indirect function in the graph, in order to make the data in the graph change. Can someone please tell me how to make...

Hi guys, so I have a userform where a person selects their choices, and based on these choices it will create a graph. All of the dynamic ranges have been constructed correctly as I have checked them several times. Everything seems to work, until I try and add series. On the...

I have a table of values. I have a graph (chart) graphically depicting those values. I have a little vba program that cycles values into the equations that make up the data in the table and the chart becomes animated as the values change. The problem: When I click the button to animate the...

I have designed a few somewhat complex graphs in Excel 2007 and whish to deploy these as an add-in. I have hence added the sheets with the graphs into my add-in and created a few buttons to copy this sheet into the ActiveWorkbook. The problem I'm encountering is graph is using several named...