Link to home
Create AccountLog in
Avatar of morinia
moriniaFlag for United States of America

asked on

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
Avatar of dlmille
dlmille
Flag of United States of America image

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
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
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
Avatar of morinia

ASKER

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.  
Ok.   I'm not understanding what I can do to help.
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"
Avatar of morinia

ASKER

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
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?
ASKER CERTIFIED SOLUTION
Avatar of dlmille
dlmille
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of morinia

ASKER

Dave,,

I don't see where you select the entity.  It is not on No Member PORG.  How do I select another entity?
Avatar of morinia

ASKER

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!!!
Avatar of morinia

ASKER

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.
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