My excel file brings up a userform as soon as it is opened. The user chooses an entry from the ComboBox and then clicks OK. This brings up another userform which has a Label at the top. I want the caption of this label to show the entry from the ComboBox on the first userform. This should be straightforward, but what I've done so far doesn't work!
I've tried:
Label1.Caption = ComboBox1.Value
within UserForm_Initialize(), but it doesn't work!
I have created a chart that provides a hisotry of events on a timeline. It relies on named ranges and allows me to change the upper and lower date ranges displayed on the x-axis of the chart by changing the date in cells that define the upper and lower dates. In order to display the events on the timeline I have a table that includes 3 columns... a date colmn, an event description column, and a event height column. To display the information I have used a line chart with data points that uses the "event height" data to determine how high up on the graph to display the event information. I have hidden the line, added a label for each event, and added an error bar that draws a line between each label and the bottom of the chart. By default the labels displayed the "event height" information (as expected), so I selected each label individually and added a formula that causes it to display information from the "event description" column instead of the default value. All of this works perfectly with no issues.
The problem comes when I change the date range displayed in the chart. Currently the chart displays event information for 1/1/2012 - 5/30/2012. I can modify 5/30/2012 to be any date I would like that is greater than 1/1/2012 with no problem. Everything displays correctly. However, if I modify the 1/1/2012 date the labels change to reflect the original value (event height data) instead of what I modified it to (event description).
[URL]
I have an export from a database that I'm bringing into Excel 2010 of about 30K records. Data points are recorded numerically and I have their associated text "value label" (what it would be called in STATA, for example, not sure what it's called in Excel). I want to create various charts/pivot tables with the data and want the labels to be the text label, not the number.
For example, variable ASSIGNMENT has the following possibilities:
1
2
3
4
Here's what each of those "mean" (I have this in another table):
1 - Sick
2 - Overtime
3 - Court
4 - Present
How do I create a chart or pivot table where the labels are "sick", "overtime", etc., and not "1", "2", "3", "4"?
I have a UserForm and what I'm trying too do is change the color property of all the labels on the form simultaneously.
View 9 Replies View RelatedI have a worksheet that is just a list of items with a location listed next to each item. I took that list and made it into a pivot table and would like it to have it list the items with each location it is in displayed across. I have already set it to tabular form in the pivot table options, but if there are multiple locations it lists them vertically and I want them list horizontally for printing purposes. I have attached a screen shot to explain.
View 1 Replies View RelatedI have a range which will change in size & in content, & I want this to be a Named Range at whatever size it is.
Reason I want to is because I want to make a Validation List with this dynamic range. I also want a Validation list which lists the content of 2 or more dynamic ranges which may or may not be on the same worksheet - is this possible?
i.e.
First dynamic range: called "Milestones" at A11
Second dynamic range: called "Activities" at A25
& make a Validation list that will list content of both
I would like to replace the blue bit of this Dynamic Named Range (DNR) with an INDIRECT formula in order to modify the starting point for the DNR: =OFFSET(DATA!$C$60,0,0,20,1). Unfortunately, I can’t seem to get my INDIRECT formula to work in order to use it to replace the blue bit above: INDIRECT("'"DATA"'!&ADDRESS(MATCH('SHEET1'!AC8,DATA_Date,0)+22,3)"). The orange bit of the formula above returns a value of 60, therefore the ADDRESS formula should return $C$60, that can then feed into the INDIRECT and act as the equivalent of DATA!$C$60. But it doesn’t.
View 2 Replies View RelatedI have a question on the above but can't seem to find a solution. There are two ways that I can find for dealing with dynamic lists via data validation:-
1) Offset and match, cavet being the data must be sorted a-z
2) Have lists for each potential selection
Is there any way to get around 1 without having to do 2? E.g. Got two columns of data, unsorted, and a list from which the user can choose from. The user chooses from the list in first cell, in the second cell require the dynamic list to return all the values accordingly?
I have a dynamic table which is linked to a couple of charts. The table must remain dynamic.
I needed to add two new columns to the table, "Focus Area" and "Category". I need a drop down list in the "Category" column to be dependent on the item selected from a drop down menu in "Focus Area".
I can get the first row of the dynamic table to do this.... however; subsequent rows all lock the drop down list in the "Category" column to the same choices regardless of what is chosen in the "Focus Area" list.
Is there a way to make dynamic drop downs within a dynamic table?
In the following VBA Code. I have a section labeled tier2 and a section labeled tier3, as you can see.
Both of the calculation formulas are refering to the items listed.
Will the code in the Tier3 section ever refer to the values in the tier 2 section, since they have the same label names?
In Excel 2003 you could use Labels in formula by enabling the Tools-->Options-->Calculation-->Accept Labels in Formula setting. In 2007 I can only find an option for using table names in formula. Is the use of standard labels no longer valid in 2007? If it is where do you enable it?
View 2 Replies View RelatedI have a basic bar graph showing the average home prices per quarter. I know I can turn the legend on and position it to show the average price on top of each bar in the graph. I would like to add an additional legend (on this chart) showing how many homes sold per quarter but not display it as a bar. I just want the number displayed maybe on the bar or below the bar. Can I add a separate (extra) legend?
View 9 Replies View RelatedI have a file with a small example of sales and % of sales for about 7 persons.
I wanted to insert a pie chart but want to show labels inside the pie chart along with % of sales and the sales person name near each part. How to do this ?
I have attached a file : Book1.xlsx‎
i create a chart in excel, is there any way to show only top 5 values "labels" in chart? just only top 5 values,,
maybe this pict can explain what i mean.. Top5.jpg
i need that chart can change automatically when i change the tables data
I have a PivotTable with data and I want to hide the row labels (in blue) that's in the first row.
See image:[URL]
PivotTable.jpg
I just received a massive worksheet full of information for mailing labels. It's all in columns-which is excel. Is there an easy way to set this up for mailing labels? I've tried to import it into word, but I'm not getting anywhere. Is it possible to change the way excel displays the cells? To a point where I can have the address beneath, then the state, zip, etc?
View 9 Replies View RelatedI have a PivotTable that is summarizing a data table. In the configuration panel, I've dragged one column ("C92") to the "Row Labels" area. Likewise, I've dragged the same column to the "Values" area, where it defaults to "Count of C93". So far, so good.
I should mention that my values in column C92 are the whole numbers 0-7 and the string "NA". But in the output chart, each of these values is listed twice! And each count of each value is different! I'm attaching a cut-down version of the spreadsheet that shows this behavior.
I am using the below formula to calculate average handling time for a call center agent then converting that to a percentage. Instead of the agents score showing the percentage I would like for it to show a "label" based on their level of performance. 50% = Below Average 75% = Average 100% = Above Average
=IF(G15="","",IF(G15<=375,"100%",IF(G15<=405,"90%",IF(G15<=450,"80%",IF(G15<=475,"70%",IF(G15<=600,"50%",IF(G15>=601,"0%",0)))))))
How can this be done?
I try to develop a special x-y graph with identical x-y-axes and straight lines representing constant values.
I try to add constant text D/E=0.25, D/E=0.5 etc. to the lines but I am not successful.
I am trying to create a macro based on a User Selection in a Combo Box. All I want this Macro to do is based on one of the 5 selections the user makes in the Combo Box, it updates two pivot tables Column Labels. I want it to first clear out what is currently in the Column Lables for the Pivot Table and then set it as follows below.
So my problem is that the ResetPivotTable calls (call function shown at bottom) clears all just about all of the fields. I am also getting errors sometimes. The first time I run it, it clears out the Column Labels and works fine. The second time I run it, it clears out everything...
So here is what I have for the first part of the Macro. This part seems to be working fine; however it is the ResetPivotTable functions that are causing the problems. These seem to clear out all the labels, but also seems to be throwing errors.
HTML Code:
Private Sub ComboBox1_Change()
Application.ScreenUpdating = False
'Refreshes the Pivot Table in case it is stale
Sheet12.PivotTables("PivotTable1").RefreshTable
Sheet12.PivotTables("PivotTable2").RefreshTable
[Code]...
'Calls function to hide all the empty colums in the report after updates have been made Call HideEmptyColumns2
End Sub
And the PivotFields function is as follows:
HTML Code:
Sub ResetPivotTable1()
Dim pvt As PivotTable
Dim pvf As PivotField
Set pvt = Sheets("Cost Summary").PivotTables("PivotTable1")
[Code]...
When I run pivot tables, the row label descriptions are only displayed at the highest level for each category. As displayed below the highest level on the row label is MOB and is only detailed in the first row. I need for each of the different row label levels to display the data so there are no blank cells.
MOBMan. Boxset 2Large1328Manual StickeringN/A500Shrwp 13+Large16680Small596Shrwrp 7-12Large35704Small2411SW 1-6Large87912Small14635SW w/ PremLarge26966OUTDisplay Lvl 1Small100Klutz Standard Display 6-packN/A2499Man. Boxset 1Large40000Man.
[Code] ........
I'm trying to resize the data labels in my chart so that the word Institutional appears on 1 line (It's currently on 2 lines) like the pic below:
but clicking the corners of the data label and dragging it does not work for me. I click on the corners and nothing happens. How I can make the data labels bigger without getting the text cut off to the next line?
Counting row labels in a pivot.
I have data from a SCCM report (user, department and application). What I want to see is how many applications a particular department uses.
If I pivot department to row label, then add application to that row label I get a list of departments and the different applications they use.
I want a count of the number of different applications.
I tried adding application to the count field, I get a count of the number of times each application is installed (depends on how many users there are per department)
I use data in column A:B to draw stacked line chart . My question: I want to add column C Evaluation on every point on stacked line chart.
Sheet1
*
A
B
C
1
*
Sales
evaluation
[Code] ...
I have a transpose copy macro working correctly, which takes selected cells in a row and copies/pastes them into vertical format for word or notepad.
I would like to however improve it by added "labels" in front of certain cells of the row being copied. These labels are found in the header row of each column, but inserting the static labels as part of the past function would work better as only certain cells will require a label.
Any clue on how to do that?
I would like not to have zero value labels in a column piled graph (it writes zeroes between one piled column and another)...
View 7 Replies View RelatedI'm having a problem modifying data on an existing chart.
I think I'm trying to add the Axis, I want A to Z, I'm getting 1 to 26
Code:
With Sheets("3.2").ChartObjects("Chart 25").Chart
.Select
.Activate
[Code]..... '
I'm a novice at Excel and need some help. We have a local area Dollars for Scholars high school chapter auction coming up and I need to sort the information that has been entered into an Excel spreadsheet (there are several hundred contacts). I need this sorted to create labels to send out donation letters. Last year we used ACT, but the chapter board wants to use Excel so everyone can have the info at their fingertips (since everyone doesn't have ACT). The information was entered in column A like the following (in rows not columns):
Name
Address 1
Address 2
City, State
telephone #
Name
Address 1
Address 2
City, State
telephone #............
I created a wedding list with a bunch of fields for each household: first name person 1, second name person 1, first name person 2, second name person 2, street #, street address, apartment, city, state and zip. Then I realized that I probably needed to combine fields for each line of the address so I created 3 combined fields: 'combined 1 ' that looks like this "joe smith & patsy cline," a 'combined 2,' that looks like "14 jones street, #3," and a 'combined 3,' that looks like "New York, NY 10037."
I haven't printed to labels for years and when I did some quick research via the help function on excel it said to print labels via word...which worked fine until i got to this section: " In the Mail Merge Recipients dialog box, click any column labels in your data that correspond to the Word identifiers on the left. This step makes inserting your data in the form documents easier. For more information about matching fields, see Word Help. "
I have no idea what this means, but here's what I need to figure out: " how do I print labels using just 3 of 8 existing columns in my spreadsheet, i.e I just want to use combined 1, combined 2 and combined 3 for the 3 lines of the address. My first instinct was just to cut the contents of the combined fields into a new spreadsheet and just do it taht way, but I created the combined fields using a formula which relates to the other fields........
lable my entries in my scatter chart:
Heres an example:
For my series 1:
I have,
_________X________Y
Brown ____1.5 ______0.1
Black _____1.2______ 0.5
White____ 1.9 _______0.2
Red ______1.1 _______0.9
Yellow____ 2.0 _______0.4
Green _____1.8 _______0.7
Now the Colors are the lables I need to put in each x and y data.
