dynamic charts

I have a spreadsheet that tracks my small business income and expenses. I have programmed a dynamic graph that charts this information, but I would like to make it more useful by being able to define the amount of months shown by changing the value in D8. Is this possible?

Hello, This is my first post. I will try to follow all the rules. First, thanks for this forum. Somtimes you just need a little help. The questions about updating a chart automaticallyin Excel 2003 has been posted many times. I am working with a row type. <TABLE style="WIDTH: 192pt...

Hi All, Recently posted on here about creating a macro to do what a dynamic chart is able to do... I have looked around at various sources on the interent, but when people do their tutorials, they always have the newer information being inserted in the rows, and not the columns. For example -...

I have created a chart on a worksheet with links to named ranges scoped to that worksheet. When I copy the sheet to a new sheet, the formulas for the series are changed to static formulas. This is a formula from the chart on the original sheet...

Dynamic Charts ... Data Problem <hr style="color: rgb(235, 235, 235); background-color: rgb(235, 235, 235);" size="1"> <!-- / icon and title --> <!-- message --> <!-- BEGIN TEMPLATE: ad_showthread_firstpost_start --> <!-- END TEMPLATE: ad_showthread_firstpost_start -->...

Hello, I am trying to created a line graph with 12-13 series that you can interact with. Like this graph below: http://img59.imageshack.us/img59/5582/excelhelp.jpg I would like to be able to created a line graph where you can zoom in 5 yrs, 10 yrs, etc. Everything I choose from a drop down...

Hi all, I'm designing a workbook for dynamically creating charts, where it will select out data using a named range (based on OFFSET, etc). That all works fine; what I'm trying to work out is what happens when you duplicate the sheet (right clicking on its tab, "Move or Copy..."). What seems...

Hey guys, I have created an array formula for a SUMIF statement that draws from a database table import (weekly copy paste to a worksheet in the workbook) based on two conditions. Because the SUMIF is based on two conditions, I have to make it an array formula. Typically when I do this with...

In the podcast 944 on dynamic charting, the solution for excel 2007 is to use tables rather than dynamic ranges, in podcast 1013 there is a formula to restrict the number of months displayed (ie last 6 or 3 months). How do I use this to dynamically resize the table to restrict the amount of data...

I want to show the last 10 data points rather than all, the formula below will show the last 10 when the data is vertical, what would the formula be if the data was horizontal? =OFFSET(Sheet1!$A$1,COUNTA($A:$A)-10,0,10) For example... If my x data was in A1:Z1 and my y data was in A2:Z2...

Hey I will really appreciate if you can help me Every day I need to do a presentation using graphics containing sales of the last week, that is, the last seven days. So, every day I ad data in the sheet, but I need to do manual change in intervals to change the graphics too, because I need to...

I have a spreadsheet which contains 1972 rows of data. The spreadsheet contains filters so a user can select to see their specific data (ie, geographic sales region). The problem is that creating a bar chart of 1972 rows makes it unreadable. So I decided to chart only 30 rows of data...