Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Manipulate Chart Data Labels Height, Width....


I m working with bar charts and as I've heard these labels can be a bit of a pain. I've got the labels in roughly the right position 90% of the time however that other 10% has me in rolling fits.

My issues
1. A label within the chart area is wrapped on two lines, how could I restrict Excel from wrappign the label
2. A Labels position covers some of the data reported and thus makes the graph messy

how could I find the position of the end of the bar and also the length of the datalabel so I could reposition it. Note I am using 2003 and that I am trying to use

activeChart.seriesCollection(s).item(i).Datalabel.left

for finding the position although this is only really where im getting to. finding the wrapping position and also being able to manipulate the length of the label is proving tricky.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Change Chart Height & Width Code
How do I write a short piece of code that defines the specific height and width that I want to assign to an existing chart. The code will be added to existing code that I have that formats the chart in other ways. This needs to be able to work with any active chart selected, not a specific named chart.

View Replies!   View Related
Picture Width And Height Adjustment
I need to paste a picture from the Clipboard to my Worksheet. I select the origin and paste it with the macro.

I need to adjust that picture to fit in a defined space from left corner of Range($J$10) to the right corner of
Range($BJ$35)

Actually, i'm using this procedure

ActiveSheet.Unprotect
RANGE("graphique_PL").Select
ActiveSheet.Paste
Selection.ShapeRange.LockAspectRatio = msoFalse
Selection.ShapeRange.Height = 358.25
Selection.ShapeRange.Width = 725.

The problem with it is, the Height and Width is arbitrary to the size of the cells at the moment. I would like to had a procedure to calculate does value. They represent the distance between the defined cells location for the image. Actually, if cells width or height change, the picture is misplaced.

View Replies!   View Related
Set Height And Width Of Cells
I am in desperate need of a macros that sets the heights and widths of columns and rows on a list of provided spreadsheets.

On each of these sheets:

MySheets = Array("FY09 Installation Support", "FY09 Install", "FY09 Purchase", _
"FY09 CF Discretionary Grants", "FY09 CF LOI", "FY08 Purchase", _
"FY08 Installation Support", "FY08 CF Discretionary Grants", _
"FY07 Sup Install Support", "FY07 CF Install Non-LOI", "FY07 Sup Purchase", _
"FY05 CF Carryover Install", "FY04 Recovery Funds", "FY05 Recovery Funds", _
"FY08 Safety Carryover", "FY09 Safety", "FY09 Transport Canada")

I need to set the height of all the rows to 18.00. I need to set the width of all of the columns to 12.00, except for columns A, C, and T, which need to be at a width of 28.00.

View Replies!   View Related
Change Column Width And Height In Millimeters Mm
I have vba code to change column width and height into mm.
The code is taking alot of time to run and then hangs my excel session.
The code below calls two sub routines.

Sub Change()
Dim i As Long

With Application
.DisplayAlerts = False
. ScreenUpdating = False
End With

For i = 1 To 23
SetColumnWidthMM i, 3.5
Next i
End Sub...

View Replies!   View Related
Freeze Column And Row Height And Width
I need to freeze the column and row height and width for a specific area in spreadsheet, so that it shouldnt be altered in future from any one using this sheet.

View Replies!   View Related
Set Height & Width UserForm Controls
I'm using a UserForm.Label to display comments which are of variable length. At the bottom of the UserForm are two CommandButtons. I'd like the gap between the Label text and the CommandButtons to be small (and preferably constant); and the CommandButtons to be at the bottom of the UserForm. This means setting the CommandButton.Top and UserForm.Height as a function of the Label.Height. The crude way I have so far achieved is to use Len(Label.Caption) as the surrogate for Label.Height but it's not very satisfactory due to word-wrap and blank lines.

View Replies!   View Related
Userform & Controls Scroll Height Width
I have a userform which has vertical and horizontal scroll bars. I want to set the scroll bar width and height properties to the correct value, regardless of the size of monitor screen used to look at the user form. I'm thought of using the code below in the initiliaze event for the user form:

Me.ScrollHeight = Me.Height
Me.ScrollWidth = Me.Width

However, this does not seem to work. I've tried adding 250 (Me.Height + 250)to each measurement, which works, but gives the user with the larger screen a very big scroll area. I wondered if there was a formula based on the application height, that would allow the scroll height to be perfect for the user form regardless of screen size?

Rico.

PS. I also use the following code to set the user form height on initialize. I don't know if that effects anything.

Me.Height = Application.Height
Me.Width = Application.Width

View Replies!   View Related
Fix Textbox Width And Automatically Adjust Height To Text
how to automatically set a text box size to display text contained by right-clicking the textbox and put a check in the auto-size box under "Alignment".

However I would like to set the widht of the text box and automatically adjust the height according to the number of lines of text. Is this possible by VBA code or othe means?

View Replies!   View Related
Speed Up Macro That Adjusts Row Height & Column Width
This used to (and on some machines still does) work very well, but all of the sudden on my work machine, it is incredably SLOW!! The whole program takes a list of tasks and dates, and creates a wall calendar from them. Then (the offending part, below in code) looks at each cell on the wall calendar and formats it by sizing the height of a merged cell so that the entire task is displayed, then goes on to put a square around it (works fine).

The formating of the cell height/width can take up to 11 SECONDS each cell. What is happening to do this? Again, it USED to, and on some machines still does, FLY through this process. But now it just crawls. Code below, with the 3 offending lines identified.

Private Sub Fit_Height(ByVal Target As Range)
Dim NewRwHt As Single
Dim cWdth As Single, MrgeWdth As Single
Dim c As Range, cc As Range
Dim ma As Range

Application. ScreenUpdating = False
With Target
If .MergeCells And .WrapText Then
Set c = Target.Cells(1, 1)
cWdth = c.ColumnWidth
Set ma = c.MergeArea
For Each cc In ma.Cells
MrgeWdth = MrgeWdth + cc.ColumnWidth
Next

An additional item (clue?) is that, after the macro is done running, it is still unbearably slow to do anything on-screen. Grabbing the column header and changing the column width takes 5 seconds or so before it snaps to the desired width and displays correctly. Closing Excel and reopening it takes care of that problem.

More advancement (as I wait). It seems to be the Application.PageSetup that kills it. As soon as I hit the first Application.PageSetup line, the app grinds to a halt, and almost every line after that that manipulates the screen format or the page format takes 5 or so seconds EACH to process. I put them all at the end, but that really doesn't solve the problem, nor explain it, nor give me a true solution.

View Replies!   View Related
Chart Data Labels
I am trying to write an If statement that returns true if Valule is checked off in the Data Labels portion of a chart. I tried using a HasDataLabel properties but Excel didn't recognize that.

View Replies!   View Related
Chart Data Labels Blanks
In a chart if you display data labels is there a way of avoiding a zero being displayed if the relevant cell is the result of a formula?
It seems that even if the result of that formula is a blank or 'n/a' it is still displayed as 0.

View Replies!   View Related
AutoFilter Changes Data Labels In 2007 Chart
I have a scatter chart and have applied data labels using the VBA macro supplied with Excel 2007. They pick up the cells in column A. But I now want to use Autofilter to show different ranges in the chart. Everytime I filter the chart data, the data labels change to show a different label (in fact they seem to be starting from the first label again, even if this value is not shown on the filter). I have tried to edit each data label and enter free text, I've also used a formula to link to the cell and made it absolute, but nothing is working.

The chart must be a scatter chart as it is plotting 2 values. I'm trying to create a Project Portfolio Risk Chart showing Benefits against Difficulty.

View Replies!   View Related
Remove Zero Value Data Labels From Pie Chart
I have a pie chart that shows numerical values in dollars and I'm looking for a macro that will delete the $0 data labels. I found this code from Jon Peltier (great website by the way) but I can't seem to get it to work on my pie chart. No errors, just doesn't do anything:

Sub CleanUpActiveChartLabels()
Dim iPts As Integer
Dim nPts As Integer
Dim aVals As Variant
Dim srs As Series
ActiveSheet.ChartObjects("MainChart").Activate
For Each srs In ActiveChart.SeriesCollection
With srs
If .HasDataLabels Then
nPts = .Points.Count
aVals = .Values
For iPts = 1 To nPts
If aVals(iPts) = 0 Then
.Points(iPts).HasDataLabel = False
End If
Next
End If
End With
Next
End Sub

View Replies!   View Related
Negative Chart Values Causes Overlap With Data Labels
I have a Column Graph that will be changing automatically as the data is changed. My problem is that for one set of data the chart looks fine....but if a number becomes negative the bar will overlap with the data labels at the bottom and cause it to be unreadable. I am not able to resize the x axis area or move the labels down any. Is there anyway to make the labels adjust automatically?

View Replies!   View Related
Add & Delete Multiple Chart Data Series Labels
My friend has set up an excel workbook with a sheet for every month (labelled Jan graphs, Feb graphs, Mar graphs etc) which has 7 pie charts per sheet. The problem is the pie charts are showing the 0% fields and the data labels are overlapping. I have found a macro that gets rid of the 0% labels but I need to repeat the macro for all the 7 charts on each sheet and all 12 worksheets for each month of the year. I am very new to VBA and coding of any type and have looked but can't find the solution.

The macro I am currently using for "Chart1" on "Jan graphs" is below. The charts are labelled Chart1, Chart2, Chart3 etc.

Sub ClearLabels()

Worksheets("Jan graphs").ChartObjects("Chart 1").Chart.ApplyDataLabels _
Type:=xlShowLabelAndPercent

For Each x In Worksheets("Jan graphs").ChartObjects("Chart 1"). _
Chart.SeriesCollection(1).Points

View Replies!   View Related
Show Chart Data Series Labels On All Series. 2007
I just recently installed Excel 2007 and I would like to know if it's possible to change all data points of a chart at the same time. In Excel 2003, I would normally hold down shift while clicking on each of the data points to make a global change. However, it appears I cannot do that in 2007.

I would like to display each data point's series name. When I go to Layout on the Excel Ribbon, and click on "Data Labels", and click on "More Data Label Options", the actual Y-axis values are shown for each data point. However, I do not want this - I actually only want the Series Name, but when I uncheck "Value" and check "Series Name" instead (under "Label Contains"), it only changes it for one of the series. Is there a better way, instead of going through each and every single series to make this change?

View Replies!   View Related
Chart More Labels
I 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 Replies!   View Related
XY Scatter Chart Labels
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.

View Replies!   View Related
Not Show #N/A On Chart X-Axis Labels
I have a chart that feeds from dynamic ranges which contain whole rows of null enteries displayed as #N/A. The charts do not plot these enteries (as it shouldn't) however it does display the category label even if it too is #N/A. Is it possible to remove the category label if all data for that row is null. ie the label is also removed from the chart.

View Replies!   View Related
Grouped Labels On Chart X-axis
I want to create grouped labels on a chart x-axis of the type created automatically when creating a pivot chart. For example: I have projects, samples and sample yields. There are multiple samples in a project so I have a sheet that looks something like this below:-

Project,Sample,Yield
2006ANG01,CTY001,1%
2006ANG01,CTY002,1.5%
2006ANG01,CTY003,1.2%
2007ANG03,CTY456,2%
2007ANG03,CTY457,1.9%

I would like to create a chart that has Project and Sample as the x-axis where the samples are all grouped into their project. Pivot charts do this nicely, but how to do it without a pivot chart? As you will see from the attached file I can get both Project and Sample on the x-axis, but the Projects are overlapping.

View Replies!   View Related
Finding The Column With The MAX Height In Comparson Wth Othr Columns Of UNEVEN Height
Finding the Column with the MAX Height in comparison with other Columns of UNEVEN Height

I need two things :

1. I have several columns starting from Column B till Column F, each column having values starting from the third ROW.

Ex:-

Lets say Column B contains two values in B3 and B4, Col C three values in C3 C4 and C5, Col D four values D3,D4,D5 and D6, Col E two values in E3 and E4, Column F five values F3,F4,F5,F6 and F7.

So, the answer is F3:F7.

2.I am using 10^{4,3,2,1,0} in a particular portion of a formula, Now the number of elements in the array or in the Curly Braces depends on the number of Columns filled from Column B as explained in the Point 1.

Now, since I have five columns under consideration I have this order as mentioned here {4,3,2,1,0} , I would like to know whether I could make this dynamic, as in if there were only four columns then this would be {3,2,1,0} and if more this array could self-fill and expand..

If that's possible, then how do we use it in the formula, Is it by the virtue of the INDIRECT function?

View Replies!   View Related
Offsetting Category Labels Along A Chart Axis
Has anyone ever succeeded in offsetting category labels in a chart by surpressing the first category label. I am plotting monthly financial data over several years and want to show category labels for the month ends which coincide with quarterly month ends (i.e Mar-06, Jun-06, Sep-06, Dec-06). If I select 2 tick marks between categories I get Jan-06, Apr-06, Jul-06, Oct-6) because my first month and category label is Jan-06. Is there a way to offset displaying the first category label by two tick marks and start with Mar-06 and then go every two tick marks between category labels?

View Replies!   View Related
Format Chart Labels For Numbers With Commas
I know from searching through the internet you can change the intervals by modifying the minimumScale, maximumScale and MajorUnit fields of TickLabels. What I want to do is change the period of the axis label to a comma. For example,

if it shows

10.00
5.00
0.00

I want it to show

10,00
5,00
0,00

View Replies!   View Related
Conditionally Hide Chart Axis Labels
Is it possible to hide some of the number labels on an axis; e.g. in on the chart below to hide the X-axis label 96? Or only start numbering from 97 while the chart displays from 96. Auto Merged Post;Well I have a solution to hiding the first value on the excel X axis values labels just using a custom number format;

[Black][>96]General;

but is there anyway of formating more than a couple of the number labels individually?

View Replies!   View Related
Position Chart/Graph Tick Mark Labels
how to put the categories (Column H) out of the graph? (so more to the left, so not in the grey background) Here in the attachment you will see that the titles are in the graph instead of outside the grey background. Is it possible to do that?

View Replies!   View Related
Match And Manipulate Data
I have some sample data in "Sheet1" and another sample data in "Sheet2".

The intended output is shown in "Sheet3".

For example: if "Student1" in Sheet1 match the data for "Student1" in Sheet2, then all the entries for "Student1" in Sheet2 will be copied to Sheet3 (ouput). The same thing goes to other students in the list (Sheet1).

Sheet1 (sample data):
Student1 | Student2 | Student3 | Student4 | Student5

Sheet2 (sample data):
Student2 | Student5 | Student3 | Student4 | Student1
Lesson1 | Lesson1 | Lesson11 | Lesson1 | Lesson1
Lesson8 | Lesson2 | Lesson2 | Lesson23 | Lesson10
Lesson3 | Lesson3 | Lesson31 | Lesson3 | Lesson3
Lesson10 | Lesson4 | Lesson4 | Lesson44 | Lesson4
Lesson5 | Lesson5 | Lesson52 | Lesson5 | Lesson15
Lesson6 | Lesson6 | Lesson6 | Lesson6 | Lesson6
...............Lesson7..................Lesson10 | Lesson7
...............Lesson20.................................Lesson11

Sheet3 (output sample):....................................

View Replies!   View Related
Being Able To Manipulate Data By A VLOOKUP
I have a dataset that has replicated Data Values for example "Bob 25" in one row, "Bob 32" in another and so on. This is contained in one data sheet. I want to be able to do something like a VLOOKUP however I want to every instance that the data value occurs to be represented sequentially in my table, so that every instance of "Bob" would be in represented in my table.

View Replies!   View Related
Userform Labels :: Change The Color Property Of All The Labels On The Form Simultaneously
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 Replies!   View Related
Import And Then Manipulate Data From Another File Automatically
I am working on a file that is going to import and then manipulate data from another excel file automatically. I would like this to be as smooth as possible and I am running into a problem. The file I am importing the data from is password protected, so I am opening it in read-only. Also, the file contains links to other excel files.

What I would like to do is indicate in the code to open the file in read-only format so that the user doesn't get a message box asking for the password. Also, is there a way to suppress the message box about updating the links? I have tried application.displayalerts = false but that didn't solve my problem.

View Replies!   View Related
Manipulate Web Page Controls To Retrieve Data
I retrieve data about local reservoirs (elevation, precipitation, gated release, ...) from a web site [url]. Retrieving the reports requires manipulating three drop boxes ("Select lake", "Year", "Data Type"). After that, I copy the data to the clipboard, and, back in Excel, push a button that pastes the text and extracts the data.

I'd like to programmatically manipulate those controls so that data retrieval can be completely automated.

View Replies!   View Related
Formula To Compare 2 Columns And Manipulate The Resulting Data And Output
I have column A and column B:

I will be inputting data into column B.

I need excel to check to see if the data I input into column B is an exact match to the data in column A.

If it is an exact match, then column B will remain blank.

If the data in column B is different, I need column B to show the following:

No match: <data>

Example I input in column B the following:

Column A Column B
1. Car Car
2. 4357 9999
3. fsd34d 4erd
4. 98dkf 98dkf

Spreadsheet should show:
Column A Column B
1. Car
2. 4357 No match: 9999
3. fsd34d No match: 4erd
4. 98dkf

(Cell 1 and 4 in column B are empty because they are exact matches to Column A cell 1 and 4)

My questions:
1) How does the excel formula need to be written for this to work?

2) Is there a way to set it so that when I do a mass copy to data into column B that the formula will not be overwritten and it will still check to see if the data I copy and pasted into that column matches the data next to it in column A?

View Replies!   View Related
Data Analysis: Manipulate The Data
I've attached the worksheet i'm working on so you can have a look. Basically, my problem is that every morning, data is pulled into the sheet in this form. The bosses want to be able to manipulate the data in Excel as easily as possible. For example, some would like to have the sum of HDD for a specific period of time for all weather stations, while others would like to have the daily values for one specific weather station.

To give you an idea of their skill level, I think that pivot tables would be too hard for them to do, and I personally dont think it would be flexible enough. Is there some way that I could write a VBA code and have UserForms that they could easily click and get the weather station they would want, the dates needed, and whether they want the HDD to be summed?

View Replies!   View Related
Increase Width Of Data Validation List
I having been looking at ways of increasing the width of a data validation list (drop-down) to accommodate items longer than the width of the target column. I found a solution here http://puremis.net/excel/code/068.shtml

The demonstration seems to do exactly what I require. However the code supplied does not work for some reason. I have run the code in debug to see what it is doing and the code runs until it gets to the line

Set objDic = CreateObject("Scripting.Dictionary")

from here it just jumps to the end of the procedure. Mousing over objDic says ObjDic = Nothing.

I am getting a bit out of my depth here - anyone know why objDic is not being assigned a value and the procedure bombing out from here.

View Replies!   View Related
Restricting Width Of Data Validation Drop Down List?
I have not found a way to control the width of a validation drop down menu. I have 3 drop down list. Two of them are in wide column cells and one a narrow column cell. For some reason my narrow column cell gives me a wide pull down even though the length of the data in this field is only 3 to four characters.

View Replies!   View Related
Data Labels Show As % Instead Actual Value
See xls file. I have this chart and the data labels are percentages instead of the actual value. How did these get that way? Under Chart Options there is a autotext box that is there but if I uncheck it, the data labels go back to the actual dollar value and that autotext box goes away.

I am totally baffeled by this despite serach the help, the internet and this forum. I am sure it is something easy I am missing.

Can some one provide some color on this?

I cut this from a larger book with many tabs because I am not able to send out the entire thing (proprietary).

View Replies!   View Related
Linking Data To Printing Labels
how to use avery 5963 labels within a workbook so that you can paste links to cells on different pages of the workbook? so that whenever the data changes it will update the labels automatically for printing.

View Replies!   View Related
Data Labels On Xy Graph From Range
Is it possible to plot an xy scatter graph of "Result A" versus "Result B", and have the data points labelled with the values under "Mix" ?

Mix Result AResult B
1340.543 0.520
1360.562 0.525
1380.570 0.526
1400.561 0.528
1410.559 0.526
1420.568 0.526
1440.570 0.526
1460.578 0.526
1470.579 0.530
1480.575 0.529

View Replies!   View Related
Mailing Labels With Table Data
I want to create labels with data that I have like you would in ms word. I asked the asst. thing in there and it has no idea what I'm typing.

View Replies!   View Related
Data Labels Points In Scatter Plot
I am attaching the Excel File along with this mail. In chart there is data points have been mentioned in scatter plot like (38,15 etc) Instead of these points I want the names that I have mentioned in column A2:A9. I used to make lots of charts related to this and it is very diffilcult for me to manually punch all these names and most importantly the thing is that I cant download the software available on http://www.appspro.com due to some issues can you give me the VBA code for this which will automatically paste these names only I have to change is the data range and its very urgent................ASAP

View Replies!   View Related
Format Data Series Point Labels
I am building stacked XY Scatter charts and having difficulty formatting the y-axis values (which are data series point labels)

Rob Bovey's XY Chart Labeler manages this fine, but I work in a strict corporate environment which does not allow downloads. Also the file will be posted on our web as a tool for all company users to extract and analyze data from corporate databases.

I am stuck on the number formatting of the labels. My file is too big to attach; I have included the code below.

I'm sure there is something very basic that I am missing. Needless to say VBA is a challenge for me.

Option Explicit

Sub Atest()

Dim intR As Integer, intP As Long
Dim sngVal As Single, sngY As Single
Dim dtX As Date
Dim chtTst As ChartObject

Set chtTst = ThisWorkbook.Worksheets("GRAPHS").ChartObjects("Chart 18")
chtTst.Select
ActiveChart.SeriesCollection("Y Axis Values").DataLabels.Delete

View Replies!   View Related
Data Point Labels On Filtered Source Range
i'm using this source to add labels to data points in charts:

Sub AttachLabelsToPoints()

'Dimension variables.
Dim Counter As Integer, ChartName As String, xVals As String

' Disable screen updating while the subroutine is run.
Application. ScreenUpdating = False

'Store the formula for the first series in "xVals".
xVals = ActiveChart.SeriesCollection(1).Formula

the code is from ms and works. (for some reason they also declare variable 'chartname' although it's never used, anyway). the full thing here: [url]

i actually have my source data filterable. so depending on the filters chosen, the chart updates itself. so it removes data points in the chart as more filters are used.

the problem is that the labels ignore the filters. the code above just goes down the column to grab the labels grabbing values in order, even if they have been filtered out.

a cumbersome workaround would be to copy the filtered data to another range and use that for the labels. this is neither optimal because i have lots of data or elegant.

View Replies!   View Related
Odd Chart: Combine Data From Multiple Worksheets And Make A Chart
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 Replies!   View Related
Chart Making- Chart With 3 Data Series
I have a chart with 3 data series. The series are located in columns A, B and C respectively. Series I is a general number anywhere from 0 to 100,000. Series 2 is also a number, but is is devided by series 1. So, if series 1 was 100,000 then series two would be 25,000/100,000 which is 0.25. Series three will always be numerator of series 2 or 25,000 in this example. The numerator, or the 25,000 will never change, so, in my example, series three will be a straight line across the chart because it is always 25,000.

In my example, the .25 is plotted on the left value axes, and series one is plotted on the right value acccess (secondary axis). Series three is just a line in the middle.

My problem is that sometimes the line, series 3, doesn't match the values in both the right and left values axes. So, if series one is 48,000, then series two would be 48,000/48,000 = 1, and series three would be 48000 - the straight line. The third series should be a line touching the 48,000 on the right and the number 1 on the left. It does touch the 48000 on the left, but is below the number 1 on the left.

View Replies!   View Related
Subtracting 2 Columns Of Data From Each Other When Labels In Separate Columns Match
I have four columns of data, as follows:

label 1, value 1, label 2, value 2

I need to create a formula in the fith column that for each line will tell excel to:

look for entry in 'label 1' in 'label 2' if there is a match, then subtract value 1 from value 2, display result.

I have tried doing this with SUMIF but am getting nowhere fast....

View Replies!   View Related
Graph The Following Data In An Area Chart With Line Charts Superimposed On The Area Chart
I am trying to graph the following data in an area chart with line charts superimposed on the area chart. I have a lot of data (and a lot going on) so I'm trying to figure out the best way to show this in excel from a functional standpoing (i can't get this to work in excel!!) to also an asthetic standpoint (dont want it to look terrible or illegible). This is what I'm trying to chart:

1) Weather data (temperature) by region:
So one region, would be: Northwest
I would like the "area" (so a shaded region) to be the min/max of the temperature data for each month.

2) I would like to show the temperature for each year as a line graph on the chart - so you can see if a year falls in or out of the shaded region.

3) I would like to show a company's sales increases across the same months per year as separate line charts. I may choose to just show the biggest outlier year in the end... or to show 2006 (the latest data).

What I am trying to convery with the chart is that the company's sales is or is not tied to weather deviations. I have attached an excel file with the data. I haven't been able to use the area chart or get a two axis chart to work or get it to look even remotely professional.

View Replies!   View Related
Manipulate Notepad Document
I'm using the following code to copy columns of data in a worksheet of mine. The code once activated will open "notepad" and copy the columns of data in my excel worksheet. Here is the

View Replies!   View Related
Manipulate Inputbox Text
I have a macro that takes input from the user and replaces certain text on several worksheets. One of the inputs is a username in the format of firstname.lastname. I need to manipulate this input such that the dot is removed and the first twelve characters only are used, all in upper case. e.g. Michael.Jackson would become MICHAELJACKS

I know how to use cells.replace to replace the text but I don't know how to use a formula to manipulate the inputbox text before I do the replace.

View Replies!   View Related
Manipulate Pivotfield Without Names
Range("B5").Select
With ActiveSheet. PivotTables("mypivot).PivotFields("team")
.Orientation = xlRowField
.Position = 2

This will move the data row field called "team" to be the second from the left. I would like a way to move whatever (without mentioning the field's name) field is in position 2 to position 3. Similar to an "offset" to the right.

View Replies!   View Related
Manipulate Text File
I have the following text file. I need to show in excel as follows:

1st column : Company No eg 006
2nd column : Expense Type eg 060
3rd column : Agreement Type eg HIP
4th column : Agreement Number Columns C&D added together.
5th column: Tot Def Expense

The breakdown above should be at an agreement level.

View Replies!   View Related
Macro To Manipulate Article Sentences
I'm trying to write a macro that will take 5 articles that I have written and separate the sentences out....

So what I need to happen is I take the articles and pop them into excel, then the macro will pick the first sentence of the first article, then the first sentence of the second article, then the first sentence of the third article....and basically repeat this for all the sentences in all the articles also while adding a "|" in between the sentences and adding a starting "{" and an ending "}" for each of the first sentences, second sentences and so on.....

I don't know that I'm making any sence here so here is a very small example of what I need to happen....

Article 1 Paragraph 1: I like blue. I like Green. I like Purple.
Article 1 Paragraph 2: I like flowers. I like dasies. I like tulips.

Article 2 Paragraph 1: I like football. I like basketball. I like soccer.
Article 2 Paragraph 2: I like food. I like wine. I like beer.

Article 3 Paragraph 1: The sky is blue. The sky is dark. The sky is night.
Article 3 Paragraph 2: I love stars. The moon is big. The moon is full.

So each of articles would need to be placed in separate sheets I'm guessing?

Below is what I need the text to look like when the macro has finished.....

Spun Article Paragraph 1:

{I like blue.|I like football.|The sky is blue.}{I like Green.|I like basketball.|The sky is dark.}{I like Purple.|I like soccer.|The sky is night.}

Spun Article Paragraph 2:

{I like flowers.|I like food.|I love stars.}{I like dasies.|I like wine.|The moon is big.}{I like tulips.|I like beer.|The moon is full.}

I hope this all makes sense.....

I already set this up using the record macro feature of excel and it works ok but I end up having to do a lot of editing because it will put to many brackets in or not enough so I was hoping for some advise or possibly some code example that could get me headed in the right direction....

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved