Creating a new spreadsheet using only one column from a group of columns

I need to graph only the  total percentage per thousand column of a specific entiity on a spreadsheet that has multiple entities.  Attached is the orginal spreadsheet and a copy of the spreadsheet I would like to use to make the graph.
Is there a way in VB code to create Chart_2 from Chart?  


Reformat.xlsm
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

dlmilleCommented:
Please advise what the three columns in each month represent - specifically, from left to right.  Chart_2 is only one data point, so which one is it or what is the operation?

Dave
dlmilleCommented:
Ok - your data helped me figure it out.  Don't think any VB is required - just some columns to create keys and some lookups.  Tried to document everything in the spreadsheet.

Does this work for you?

Dave
Reformat-GraphEntities-r2.xlsm
dlmilleCommented:
Use this one...  You can select what to graph (IP, Mbr, TOT, etc.) and can graph all values for one entity.  I think this matches what you had + a bit more in the related question.

Dave
Reformat-GraphEntities-r2.xlsm
Why Diversity in Tech Matters

Kesha Williams, certified professional and software developer, explores the imbalance of diversity in the world of technology -- especially when it comes to hiring women. She showcases ways she's making a difference through the Colors of STEM program.

moriniaAdvanced Analytics AnalystAuthor Commented:
Dave,

You have given the solution as to how to pick an entity and plot it, however to get from the originial spreadsheet to the spreadsheet that you are using is the problem.  I am dealing with an interactive spreadsheet so that is why I am trying to automate the process of getting the original spreadsheet into a format that I can now select the entity to plot.  
dlmilleCommented:
Ok.   I'm not understanding what I can do to help.
dlmilleCommented:
Are you saying that Chart_1 spreadsheet can't be touched?  Give me more to go on.  I don't know what you mean by "interactive"  - all spreadsheets are "interactive"
moriniaAdvanced Analytics AnalystAuthor Commented:
Dave,

I have attached the interactive spreadsheet.  You will now see what I mean.  Go to NY_Select and click on a code under column A.  This includes New York and New Jersey.  

Once a product is selected now I am trying to give the option to select an Entity to chart.
PORGS-1.xlsm
dlmilleCommented:
So - after the product is selected, you'd like a sheet like Chart_2 that I created that allows you to select an entity and graph, correct?
dlmilleCommented:
Ok - I think I've integrated it in with your interactive work.  Chart_1 just pulls the data over from the NY_Select, then Chart_2 and the graphs work from that.

Take a look and let me know!

Dave
PORGS-r1.xlsm

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
moriniaAdvanced Analytics AnalystAuthor Commented:
Dave,,

I don't see where you select the entity.  It is not on No Member PORG.  How do I select another entity?
moriniaAdvanced Analytics AnalystAuthor Commented:
Dave,

I see the selection now.  Sorry, I missed it.  This looks like what I want.  Let me try it for a while to make sure I have no more questions.

Great job!!!
moriniaAdvanced Analytics AnalystAuthor Commented:
Dave,

It appears that the chart is changing correctly, but the vertical axis seems to be off.  It is repeating numbers  .01,    .01,  .02, .02 so the plotting is off.
dlmilleCommented:
Go to tab Chart_2

Select the chart data (at the top) D2:O6

Format to have more decimal places

The chart will have the same format
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.