Dynamic Charting

[Khalil Lakhani]

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 change the Y axis dynamically according to data.
Attached file contains one such Cohort -

thanks guys!!

 

[Nebu]

Hi:

I cannot see any chart on your workbook, upload a complete file.

Thanks

 

[Khalil Lakhani]

Here's a file with chart -

 

[Nebu]

Hi;

You are still not clear abt what you want. I understand you want a dynamic graph based on drop down, this can be achieved using formulas, but I am unable to understand the relationship between your drop downs and your data set. If you want a solution give us full info with proper explanation. You can get a robust solution only if you are really committed to finding one.

Thanks

 

[Khalil Lakhani]

Sorry Nebu for not clarifying enough - I am trying to figure out two things -
- When the chart is plot it automatically avoids null and zeros -
- also, drop down menu has different products and each have different datapoints on X axis - So I want to make both axis dynamic -
I have attached a different file that shows data and chart -

Thanks again!

 

[Nebu]

Hi:

Find the attached, I have used named ranges to fix the graphs.

Thanks

 

[Khalil Lakhani]

Thanks Man!! - You made it look so easy -
Do you know how to make X and Y axis dynamic as well, where the markers on axis change according to data?

 

[Nebu]

Hi:

What do you want your X axis and Y axis to be? I believe you can do it yourself using 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.

Thanks

 

[Khalil Lakhani]

Thanks! I will go through the link -