Make Chart That Will Constantly Change As Different Selections Made By Person?

Jun 18, 2014

I have created a spreadsheet which uses data validation to allow a user to select a company, start Date, end date, and projected months in order to output different figures. I have attached a spreadsheet to this post in case that was hard to understand.

Since there is data validation, indexing, and matching going on, as different selections are made, various tables change as a result. What I mean as you open the example sheet and start messing around with the data validation boxes.

The problem I am encountering now, is creating a chart that will also keep changing as the user changes their selections in the data validation boxes. I am unsure if this is even possible, but I figured it was worth a shot to ask. On the example sheet, I have included a graph similar to the one I want, but it only contains data in a certain range of cells, rather than dynamically changing to accommodate whatever data is outputted.

Here is what I am looking for in the graph:

1. Whatever dates are selected by the user in the data validation boxes, along with the projected dates will be on the x-axis.

2. The PMPM figures associated with the selected dates, and the projected dates on the y-axis.

3. Ability to make different selections from the data validation boxes and still have a dynamic chart that keeps updating itself.

View 2 Replies


ADVERTISEMENT

How To Make Audit Trail When First Change Is Made Right After Opening Excel File

Jul 30, 2012

Pls see below codes, the codes can record down changes made "from" and "to" and put on the "Log" sheet, however it is unable to capture the original values when I first open the file and make the changes.

Also, how can I put the value of "Now" in column B?

Code:
Dim PreviousValue
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value PreviousValue Then

[Code].....

View 9 Replies View Related

Number Of Calls Made By A Person In A Month

Sep 5, 2013

The first column is "Person Name" and the second column is date in format "6/27/2013". I want a formula to calculate the total number of calls a person made in the month of June.

View 2 Replies View Related

Log UserID Of Person Who Last Made Update In External File Links

Oct 2, 2006

Is there a way to log the userid of the person who last made an update in the external file links?

View 4 Replies View Related

Shrink Validation List As Selections Are Made?

Feb 19, 2012

I have been working on this data entry and validation tool for work for a while now. I've got most of it down and works just as I want it to. However, I have made some validation lists for people to select and animal ID when entering some data. Once the animal ID is entered I want to remove it from the source data and the list to stop people entering a duplicate number for the same event.

I'm not sure how easy/difficult this will be but the whole reason for this project was to stop people entering the same data and only allow them to enter data that I pre-define. Its to cut down on mistakes where somone will enter the wrong ID and then finding the correct ID becomes difficult due to having over 4000 animals on site.

View 3 Replies View Related

Make For Loop Run Constantly?

Sep 9, 2012

I have this code:

Code:
Sub StaffDateFiller()
TodayDate = Worksheets("Program").Range("I8")
StaffName = Worksheets("Program").Range("I9")

[Code]....

Is there a way to either:

A) make this run constantly (as it stands now, the code works as I want it to, but I have to run the code for the operation to take place)

B) perhaps write it somehow using indirect reference (I am not sure how to do this), so that I do not have to constantly have the code look through a bunch of rows.

I simply want to check if an 8-digit value occurs in column 7, and take information from somewhere else and paste it into column 8 and column 9 of the same row.

View 9 Replies View Related

Counting Selections Made With Control Toolbox Controls

Apr 12, 2007

I am attempting to put in some dropdown boxes and text boxes and maybe some other items using the control toolbox in Excel. After a selection is made I would like to count that particular item. I was using the validation method in which all I needed was the following to sum up the selections made: =SUMIF(G:G,"Monday",I:I)

Now I realize this will not work due to the fact the control toolbox controls are embeded and merley sit on the cells. How do I sum selections made using drop down boxes that are derived from the control toolbox? If someone can give me an example to try or point me to a place to find such information that would be great.

View 2 Replies View Related

Formula To Find Value Of Cell Based On Selections Made In Two Other Cells?

Feb 2, 2014

I am making a form with drop down boxes and auto fill to make things easier. I have one Box for the Company selection another box for the occupation selection and I need a formula to find a $ value based on the selections made in these two cells. If I could establish the actual cell reference of the selected data in the second drop down list. The data will be much larger than this example and will live on a separate sheet.

View 2 Replies View Related

How To Change First And Last Name When Person Has Middle Name

Apr 4, 2014

I have a worksheet with some names in a column with a persons first name then the second name and I would like to place the names in a different column I can have this to work ok with the following formula

=MID(A1&" "&A1,FIND(" ",A1)+1,LEN(A1))

This works ok but I have people with three names like Peter May Jones

When I have changed the name I would like to have (Jones, Peter May) but I get (May Peter Jones)

Also the colon I have after the first name gets put at the end of the name not after the last name.

View 12 Replies View Related

Make A List Of Selections For User To Choose From In My Combo Box?

Jan 8, 2008

How do I make a list of selections for user to choose from in my combo box?

View 9 Replies View Related

2 Separate Selections In 1 Series For A Chart

Jan 3, 2007

Hi does anyone knows how can I do a chart with 1 serie with the next values using the 2000 version of excel (not using row number 3)? .......

View 9 Replies View Related

Customize Chart From Combo Box Selections

Jun 5, 2007

I'm trying to allow a user to chose from four different variables through combo-boxes as their Y and X coordinates to be displayed in a scatter plot. I'm able to populate the combo-boxes but don't know where to go from there to apply this to a chart.

View 9 Replies View Related

Changing Chart According To 3 Selections Of Validation Data (list)

Nov 28, 2012

I would like to find out how can I create a chart, where it is interacting with the selection of 3 drop down list (created from data validation-list option). It will show up to 12 months of data.

First list would have only Male & Female, 2nd list would have 1st Class, 2nd Upper, 2nd Lower, 3rd Class and Pass Only, 3rd list would have all the months of 3 years.

My data is from J9:U22. These data needs to be changed accordingly, reading from D45:U58.

For the graph, if I select Male, 2nd Upper, and Jun-2012, I want it to show only this selection, where the period will be from Jul-2011 till Jun-2012.

Previously I have done one, with only 1 selection of drop down list, where I used Vlookup. Now involves 3 criterias.

Or is there an easier way to do it?

View 3 Replies View Related

Running Macro When Change Made To Worksheet

Feb 16, 2012

The intent of the code below is to run the marco HideCol when a change is made in cell C10. If I actually change the value in C10 it works. However, I have C10 linked to another worksheet (=anotherpage!A13). When the value changes, my macro is not executing.

Here is the code:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim changed As Range
Set changed = Range("C10")
If Not Intersect(Target, changed) Is Nothing Then
HideCol
End If
End Sub

View 3 Replies View Related

Odd Chart: Combine Data From Multiple Worksheets And Make A Chart

Mar 26, 2009

I am trying to combine data from multiple worksheets and make a chart. I have about 200 keywords in every worksheet (about 50), and some of them repeat themselves through worksheets and some don't. For every keyword, I have an associated value in the next column that I want to portray over time (each worksheet is for a different period).

So what I need to figure out is how to be able to pick any 10 keywords from the worksheets and put them in a line chart where I can see the associated value for each period for every worksheet so I can compare my keywords' efficiency. The tricky part is that some worksheets do not contain the keyword and other worksheets contain the keyword in a different cell than the previous wsheet.

View 4 Replies View Related

Identify The Cell Address Of Last Change Made In Sheet Using VBA?

Aug 13, 2012

I am using an event macro to trigger a set of calculations. In the spreadsheet, users have a choice of 3 input cells to work out an answer; these 3 cells work out the same cost from different angles depending on the variables available to the user.

Users only ever need to fill in one of the three cells to work out the answer as the event macro I designed, should (upon input by the user), work out the remaining two input cells using logical arguments.

The macro and calculation work fine, except in the event of users amending a value in an input cell previously updated; in other words, if all 3 cells contain a value and 1 of them is being changed by a user.

The issue: I need the event macro to recognise the location of the last change made by the user in order to determine which 2 of the 3 cells need to recalculate. However, users will invariably press enter or tab etc... upon making changes and this has caused me issues so far.

What I have tried already:

1) running another event macro "on selection change" to record elsewhere in the model all cell selections as and when the user interacts with the model

EFFECT: it made the "on change" event macro very slow and clunky; so I need to avoid
2) declaring a range as set r = activecell.address

EFFECT: this did not work as the active cell's address would in fact be the address on the last cell; e.g. the one selected further to pressing enter (often the one directly below the cell recently changed)

A solution to add to the existing "on change" event macro that identifies the last edited cell

View 8 Replies View Related

Change Text Colour When Entry Made In Another Cell

Jan 10, 2010

I am using Excel 2003, my problem is that I have cells D4 & E4 with red text, when an entry is made in B4 (say $640, the amount can vary) I want the text in D4 & E4 to turn black. I have attached a section of the document in question.

View 5 Replies View Related

Texts Automatically Change The Currency Depending On The Choice Made In The Previous Userform

Jul 3, 2008

I have options buttons in a userform, first is "$" the other is ""

When somebody chooses one of them, it writes the choice to a cell in the data sheet. But when clicked on the next userform I want some of the texts automatically change the currency depending on the choice made in the previous userform.

The formula below was is example

=""&Data!$A$2&" / m"

=""&Data!$A$2&" / kWh"

View 9 Replies View Related

Excel 2011 :: Change Default Formats Of Number Selections In Tool Bar?

Jul 28, 2012

In the toolbar there's a section titled "Number" which allows you to change cell formats with selections named General, Number, Accounting, Date, Time, etc. I want to permanently change some of their default formats.

For instance, currently when I select Number the default is -4000.00. I want to PERMANENTLY change its default to (4,000.00). How do I do this?

View 3 Replies View Related

Swap 2 Mouse Click Selections After Resizing Selections

Jul 7, 2013

I am trying to take two random Mouse click selections and swap a set of ranges associated with the cells that are selected. For example if the user clicks on A1 it will resize(3,22) and store the selection as a variable to be swapped with another selection. Here is what I have so far but I keep getting a object required error on rngEmp1.

VB:
Sub SwapGroup()
If Selection.Cells.Count < 8 Then
MsgBox "Please Select two Groups to swap. Press and hold 'Ctrl' in between your selections", , "Swap Groups"

[Code] .....

View 4 Replies View Related

Using VBA To Make A Chart

Jul 16, 2009

I have the following code to create a 3D line graph:

View 2 Replies View Related

Change Chart Series Pasted From Another Chart

Jun 19, 2008

I want to use a macro to change attributes of a series in a chart. Unbelievably, if the series has been pasted into the chart from another chart, and although the macro can address the series and even return values (eg name) correctly, the selection simply cycles to one of the original series on the chart.

View 3 Replies View Related

Make A Chart By Using Macro

Apr 29, 2006

I am trying to make a chart and I just used the macro recording thing to get the code. I have a variable called days.

ActiveChart.SeriesCollection(1).XValues = "='Pair Data'!R2C2:R24C2"

Instead of going to row 24 I want to go to row days+1 so I did the following:

ActiveChart.SeriesCollection(1).XValues = "='Pair Data'!R2C2:R"&days+1&"C2"

how I can fix it? It highlights the "C2" at the end and says Expected End of Statement.

View 2 Replies View Related

Pivot Chart Object: Find Any Suitable Object To Choose From To Make A Pivot Chart In Powerpoint

Mar 21, 2007

1) i have office 2003 on a laptop. within powerpoint, i can create a 'microsoft excel chart 11' object. to create a link to the excel data source, do i have to go through the odbc sql setup? it works, but i don't want my powerpoint to be dependent on some excel file somewhere. what are the other options to insert/make a functional pivot chart in powerpoint with the data also within powerpoint? the data as sheet option does not result in the chart being a pivot, it's just a plain chart. it has to be a proper object, not an image paste or a chart that updates links with the excel file open.

2) i have office 2007 on my other laptop. i can not find any suitable object to choose from to make a pivot chart in powerpoint. what's the best way to go about in 2007 version?

3) am i going about this the wrong way with the objects? should i be after vba code?

View 4 Replies View Related

Make A Chart With Data From Several Sheets

Mar 22, 2009

I want to do is be able to take The data from one week for every store and compile it into a chart to show a summary of the company as a whole. I know that I can reference from that chart to each worksheet the values I want, but how would I give that chart the ability to update each time I add a weeks worth of data.

I have attached a file that shows what I am talking about. The sheets labeled Waterloo, Mogadore, through Green are the sheets for each store.

I want to take the last weeks data and put it into a chart as seen on Sheet1. Then when I add data for 3/21/09 I want to make a new chart without retyping the data into the chart.

View 2 Replies View Related

How To Make A Chart Using A Dynamic Range

Apr 17, 2014

I have never used charts in excel unfortunately. I just finished watching a few tutorials but still a little confused. I have a WS with a list of items I want to make various charts of how do you make a chart that adjusts when new items are added? (thus dynamic data) Do you need a macro to do this or is it just standard by defining a range within that sheet?

View 7 Replies View Related

Make Line Chart From 3 Series

Jan 8, 2010

I have data:

Jan Feb Mar Apr May
2009years 56 45 42 50 62 - series1
2010years 48 47 45 48 55 - series2

I need make line chart from 3 series. First two are series1 and series2. Third is percent change between 2010 and 2009 years every month (series3). First two are easy, but third is very difficult for me, becouse I haven't row with percent change and I can't haven't it in my exercise.

How can I make it without new row with percent change?

I tried it with Data Source in chart, also formula in Name Manager, but it doesn't succeed

View 9 Replies View Related

Make Chart Series Dynamic

Oct 3, 2007

I would like to update a chart after I have updated the underlying data just by clicking a button and displaying the updated date in the chart. Does anyone know how to do this? Currently I am having to manually click on the graphs line in the chart, which highlights the columns data, then manually extend this for the chart to update. And then I am manually typing in a date cell in the chart. There MUST be a cool way to do this.

View 6 Replies View Related

Make Chart Series Open Ended?

Jan 7, 2013

In a chart series, I have and end number for a row that I have been updating manually everytime I enter a new fuel tank fillup. Is there a simple way with the chart series to just say always go to the last data in the specified column?

See my example here, instead of the 137 in the series is there someway to just say "last data row"?

[URL]

View 1 Replies View Related

Make Simple Chart Showing Angles

Feb 8, 2013

I'm trying to plot a chart of some sort in Excel to display 4 angles that different blood vessels branch off the aorta. Ideally I'd like to input the values of these angles which would vary from patient to patient and have them be displayed in some kind of chart. The chart I'm hoping to achieve would be cirular with the 4 angles represented by spokes which extend out all of the same length. I've attached a rough sketch to show what I'm trying to achieve and I'd be hoping to be able to change each angle in a worksheet and have the chart update to reflect.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved