dynamic chart data

Hello, I am working on a template for charting data. I want to be able to use a dynamic named ranges for series data so the chart is dynamic and I don't need to manually update the series data everytime. Sample number is x axis and Average Weights is the y axis. I made the dynamic range names...

Hello to all, I have a conundrum. I have a work book with multiple sheets. I am trying to make a chart that is a continuous rolling chart of the last 365 days of sales. The sheet that has the data is called DAILY VALUES, the sheet where I would like the chart is called 100LL Monthly Sales...

Hi, I have created a chart referencing data from a table. The first column in the table (A) is a formula that basically says if column B in the same row is not blank, then add a day from the date above. I paste a new month's data (via macro) in every so often and the date then appears and is...

I have a large spread sheet with a ton of data that changes monthly. I created a drop down (data validation) that allow the user to choose which "actions" they want charted. I am using the following to reference the drop down list to a range: =IF(ActionList="","",IF(ActionList='Analytics All...

Hello I've got a reasonable amount of experience with excel but I'm a bit lost in this situation. We are trying to create a dashboard that is displaying information for different locations. The goal is to provide a combo drop down box that lists each location. When you select a location all...

Hello! I'm completely new to this forum and my knowledge in excel is scarce. Searching for similar posts is hard and that's why I decided to make a new post. So. I'm using Excel 2012 and have a large excel file. This file contains these kind of worksheets: data of items (each worksheet...

I have two worksheets in a workbook (WellbeingDashboard); Charts and Data. The data I am looking at includes product data (five products), accounts and user metrics (two metrics), by state (two states). I am trying to create a single chart (stacked area) that trends the change in a user-selected...

I have scoured the forum for tips on Dynamic Ranges of graphs, in particular a scatter graph. I can't find a solution to the problem that is happening for me. When a user receives a copy of my spreadsheet, the name gets changed. But because the name gets changed, the named ranges that I am using...

I have 5 sets of data I'd like to be able to display using only one chart that is controlled by a listbox. I've tried a couple of different lines of code and searched to find an appropriate answer for this without any luck. Anyone willing to help? Private Sub Worksheet_Change(ByVal Target As...