How do I create a list that will chart each series

[Coal]

Hello,
I am a brand new forum member and was looking for some help.

I have a spreadsheet with about 400 lines representing categories and several columns representing months. I'd like to create a drop-down list that would allow me to select one of the categories in column A from the "Growth" tab, and have a line chart be created with the monthly values of the component. I have cut out a lot of the data to upload the file.

Is this possible?

Thanks again,
Coal

 

[3G]

Hi Coal

Try this on for size. I just used the entire COlumn A for the categories. You can add some data validation to allow multiple drill downs (i.e. Goods>Durable Goods>Autos>etc). However, based on your text above, this is somewhere to start. You can nix the data labels, and mess with the formatting as you see fit.

Post back if there are some other things you're interested in adding/etc.

 

[SirJB7]

Hi, Coal!

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, give a look at this file:
https://dl.dropboxusercontent.com/u/60558749/How do I create a list that will chart each series _ question from a newbie - US Inflation_short (for Coal at chandoo.org).xlsm

It's a sample file to show you the technique, you'd polish the chart presentation.

This is the code for worksheet Growth class module:

Option Explicit

Private Sub lstCategory_Change()
    Const ksRngTitle = "DateList"
    Const ksRngData = "SelectedItemList"
    Const ksChart = "DynamicChart"
    ActiveSheet.ChartObjects(ksChart).Activate
    ActiveChart.SetSourceData Application.Union(Range(ksRngTitle), Range(ksRngData))
End Sub

Regards!

PS: If it's about inflation, ... be my guest!

 

[oldchippy]

Hi,

Try this one using a data validation list

 

[Coal]

3G -- Many thanks. This is superb!