dynamic chart range

Dear All, I really need help, I have checked on internet but can't seems to find an answer for my problem. Basically I am looking for formulas where new Expense category will be added (not that frequently) in rows and in the columns new months will be added and a graphs will be linked to the...

I am trying to create a chart with a dynamic range pointing to cells that have formulas in them (in this example - the yellow range). If the formula returns no data, I want those cells to be ignored. This video (How to Create a Dynamic Chart Range in Excel) shows what I am trying to do, and it...

Hi, Some guidance would be appreciated. I have a performance report for each team in my workplace. I have dynamically based the charts on the one cell where I have my validation list of team names. I subsequently have a macro set up to run through the list and save the report to PDF. I'm...

Dear all, I carefully read though Forum postings regarding dynamic chart ranges using this Function for defined Ranges. =OFFSET(DynamicChart1!$B$2,0,0,COUNTA(DynamicChart1!$B:$B)-1) This normally ensures that the Charts get resized not reflecting empty rows. However, one of the column uses a...

Hi All, It’s my first post in this forum so hopefully I’m following all the rules correctly ;). Anyways, I hope someone can help me with this this “dynamic charts” question. Here is the situation: I am trying to create a bunch of combo charts, and part of the combo is a line chart. For the...

I have a worksheet set up as follows: Column A is a list of dates Colums B - Z have list of various data valuses grouped by Various Skills (seperate skill in each Column) I have Named ranges for each Skill and the Date column Using the Offset function to...