Search results for query: dynamic charting

On which version of Excel are you working? Modern Excel comes with dynamic arrays, and you can reference them in chart series. There is a chapter on Chandoo's blog post. Look for the filter function. https://chandoo.org/wp/dynamic-array-functions/ However, he was incomplete on the charting...

The set up: I have a data set (example attached) that I update daily by appending new rows. There are two tabs of data (Prof and Meas) and one tabl for charting (Pareto). For the data tabs, column B and C are the same. Column B contains a discriminator (WO Number). Column C is the unique...

Hui, Back in 2019 you demonstrated the solution to a charting problem I had been attempting for many years. "pct_circle_chart". Back in 2009 I was going to bore and stroke the engine in my modified Jeep Cherokee and wanted to build it in Excel before doing so physically. Many years ago...

I hear you. I rarely do not use ordinary charts too. It somehow surprises me you say PowerPivot is unknown territory. I reckon, since you are a master in structured references, you should rapidly feel much comfort with it and DAX. But it is an investment: it takes time to learn and practice...

@GraH - Guido I spend ages agonising over what was the best approach to the data analysis. The options I considered were 1. Stay within my comfort zone and base the entire analysis on dynamic array formulas 2. To use PQ for the initial filtering and transforming and then use formulas to create...

Hello All, I have few data points where in I need to insert a separate column for average of two variables.The average column is manually inserted. I have a challenge in pie chart where in I have to show: Each KPI Week wise Average ( Depends upon on number of KPI's in Header) All KPI together...

Dear Charting Experts, I'm trying to figure out how to draw a correlation chart using the data attached in the excel file attached. Just want to look my chart attached in the "Sample Chart.png ". This chart should be dynamic ie when i update new data from 30 Jun-07 this has to get updated in...

XL Dashboard of ALL UK Occupations 2016s: Dynamic Charts on 1st tab & 3rd tab.. Objective to make 1st tab even more Dynamic, hence not to display blank columns of City per Industry, as seen in less sophisicated 3rd tab. Difficult in 1st tab due to additional header, seen in 9 categories at...

I am looking for an example of how to Comb Chart Non-Contiguous Data from a worksheet that only has data in Columns B through I, $b$4:$i$299. Selecting the separate columns is easy (e.g., Column D and H), but what about when you only need cells labeled "Adjacent" from one column and the...

...offset formula I had given for other named ranges, its just a matter of changing the cell references. If you want to learn more about dynamic charting go through this link http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/ he has uploaded sample file with examples on this link...

Hi, I have few cohorts of data with variable data on X and Y axis. I'd like to select those cohorts from drop down menu and would like to see data converting to charts. I have done that part. My Question is how do I avoid blank or NULL cells from inclusion in the chart. Also, is there a way to...

...pull from their file where the data is inputted to track how many parts are consumed from day to day, week to week, etc. I also need dynamic charting which shows # of parts on hand and # of parts ordered, which auto updates as they order throughout the year. I have been trying to use pivot...

Hi, I have a set of data which relates to events which happened along a run line. I am trying to plot these events at the location they occurred on the run line. The run line itself will be 394km, I'll be adding scrolling to the chart at some point, but I have not been able to get the data...

...what charts to build. There are a plethora of dashboard examples here at Chandoo. You could either use one of them as a template, or at least get some ideas and then let us know what you are wanting to get to. There's also several wonderful guides on dynamic charting here, or at Jon Peltier's...

I have used the OFFSET formula in the name manager for charting ranges before but with this example I need to include more than just one row of data and the Offset only seems to work with one column or row at a time. I want my values in the line chart to stop when there is no data found not drop...

Hi Portucale.. Thanks to Excel 2013.. it almost take care of every customize in a single place.. http://www.techrepublic.com/blog/10-things/10-cool-new-charting-features-in-excel-2013/ However in case of prior 2013 excel version, You have to use some formula based approach to dynamically...

I think Chandoo's recent post may be helpful.... http://chandoo.org/wp/2014/02/13/dynamic-cascading-dropdowns-that-reset/?utm_source=feedburner&utm_medium=email&utm_campaign=Feed%3A+PointyHairedDilbert+%28Chandoo.org+-+Learn+Excel+%26+Charting+Online%29 Wow, that's a long URL.....

Chandoo, I am a big fan and had a pressing vba charting question. I have a set of dates (x) axis and several y1,y2. My y data set looks like Mar 2010 April 2010 March 2011 April 2011 so on and so forth until April 2020( future options data). What I need to do is use vba to chart this data...

Hi, Pedro Costa! As a new user you might want (I'd say should and must) read this: http://chandoo.org/forum/forums/new-users-please-start-here.14/ And regarding your issue, if you use the built-in search at top right, you'd probably get these entries, which surely will help you...

Hi Greg, See if the following article helps you: Charting with non-contiguous data Cheers, Sajan.

Hello, I am not sure that dynamic range in charts is going to solve this problem or not? I have 3 rows of data and say 10 columns wide that I need to chart 2 of them on. Row 1 has data Row 2 is blank (based on other Excel conditions) Row 12 (or some other row number) has the data that I...

The dates are only hidden because you haven't listed them. If you want to keep adding to them, I suggest checking out Jon's article on dynamic charting to help you get started: http://peltiertech.com/Excel/Charts/DynamicCharts.html http://peltiertech.com/Excel/Charts/DynamicColumnChart1.html

Hello Ann, It sounds like you are looking to conditionally plot a data series (that might be the result of a sum of similar rows). If so, try the following approach: To be able to plot data series dynamically, you will need to utilize Named formulas as the source data for the chart. The...

Hi Everyone , VBA newbie in town I regular visit chandoo website to improve excel skills (mainly charting) Now starting VBA ( as my boss has asked me to make dynamic to do file after first sucessfull project) hope I can get some support from Chandoo & Co grtz

hi guys, i need to create a dynamic chart where the months are in columns as opposed to rows. it should dynamically chart for the last 12 months.. jan12 , feb 12 , march 12 , april 12, may 12 kemsa : 122 332 555 666 777 kenya pharma: 333 443...