dynamic chart

Hi, I have this data which I would like to put in a bar chart. The problem is that when I change teams, some have more staff than others so I need to graph the whole 20 rows but only display the ones with data. The empty cells have formula in them so are not true blanks. It is not viable for...

Hello, I'm using WinXP with Excel 2007. I would like to chart a range of summarized data that includes future dates. The range is B3:U110. All the cells in the range have formulas that link to where the data is entered: 'C:\ProdGuys\a PRODUCTION DATA\Set up Times\2012\[01 jan print...

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

Hello I'm new to the board.... I am learning VB.... I have just inherited some charts.. which requires update fortnightly.... I have to copy A2:I2 with all the formulas, paste and shift down(done using macros). The chart will then be updated using A1:D28.... everytime the you add a new...

Or so I believe it is! In column A, I have a list of every country in the world, and regions within these countries. In row 1, I have Months, starting in September 2008, going all the way to September 2016 (96 columns). B2:CT387 contains my data, which is sourced automatically from IBM...

Hello, I watched a ton of your videos on the Dynamic Chart series and I feel like I got a decent grasp on the different things you can do, but now I can't figure out what choice makes the most sense to do my work project. I'm using Office 2010 on Windows 7 64 bit My boss has a massive...

I have a twist on the "Excel Dynamic Chart #10: OFFSET Function Dynamic Range" method. I want to create a chart that only shows the sum of hours a person works for the four weeks after the current Sunday. So I have all the Sundays (Dates) in 2011 listed from J7 to BI7. From row 8 to row 40 I...

Hi, I have a single spreadsheet with dates in Column A and measurements in Column B. I am trying to create a chart with a dynamic date range from 5 years ago to YTD. When a user enters a new date and data, I would like the chart to display the added data, calculate what 5 years prior to this is...

I'm trying to dynmically change a chart series. I can do it manually fine however, when I try and run an update macro to change the name there are extra quotation marks that get added and the dynamic bit fails. Hope this is easy ... Thanks ======================================== I have a...

I have designed a couple of graphs using named ranges to give dynamics to the number of series in a chart. This works fine as long as I don't want to copy and/or move the sheet to a new work book. When I do this, Excel chooses to remove all references to the named ranges in the SERIES forumla...

Hello everyone, I've been reading this site for a while :pray:, this is my first time posting. Problem: Need to create a Pareto Chart (dynamic) Data: 11 Stores 42 categories (altogether) Not all 11 stores have data for all 42 Categories What I know: I have managed to exclude the...

Hey everyone, I have what should be a fairly simple problem that has been taking me forever to figure out. Here is my situation (Using Excel 07): I'm going to be inputting 100 numbers into a column (Say B2:B101) and need to make a histogram out of that at intervals of 1 from the lower bound to...

I have a chart with a dynamic range. I have certain marker/line types/colors I would prefer each series in the chart to have. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> For example if my dynamic chart has 5 series and I do the...

I have one cell in excel 07 whose data (it is a number) is fed from an outside source. this cells data updates every second. how can i plot the data in a chart so it plots the data live as the data updates every second. when i tried, it just plots the one point in a graph and as the data...