MS Chart Object 11.0 VBA Filter
I have a MS Office Chart Component (11) on a userform. I am trying to programatically change the item in the filter (page) area (only one field) using VBA. The source is an OLAP cube ( SQL AS 05) but don't think that's particularly relavent because I can't do it even if the source is a range.
The object comes as a ChartSpace on the userform. I have found a reference (using the watch window) to the current filter selection in ChartSpacex.InternatPivotTable.ActiveView.Fieldsets(0).Fields(0)....
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Pivot Chart Object: Find Any Suitable Object To Choose From To Make A Pivot Chart In Powerpoint
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 Replies!
View Related
Check Before If Chart Object Exist
I wrote a macro that selects 3 charts existing in a sheet and sets the axes to auto scale option. The charts are labeled Chart 2, Chart 6 and Chart 7 by default, the macro selects each of then and then sets the auto scale option. Is it possible to use 'If then' statement to check if the chart object exists ? In case they do exist then macro works on them but if not then it goes to the next statement. Or is there any other way to check if objects exists or not, because sometimes the macro is used for old files (template) and the chart objects there have different numbers and not 2, 6 and 7. So to use macro for both templates( new and old) its better to check first. This way the macro becomes more flexible.
View Replies!
View Related
Create Macro To Chart Data With Location As Object In Active Sheet
I have been trying to create a macro in excel to chart a selection of data and to output the chart on the active sheet where the data was taken (as opposed to a named sheet). So basically, I have about 300 worksheets with data, and I would like to have a button on each page that automatically charts that data when clicked, and outputs the chart to the page where the macro was clicked. However, I have not been able to figure out a relative reference that will allow me to make the LocationasObject reference simply the ActiveSheet as opposed to a specifically named sheet. See my code below, which references an output to a worksheet called "Charts". Right now, all of my charts are outputting to the sheet called "Charts", as opposed to the active sheet. Sub ConsDiscChart() ActiveCell.Offset(29, 11).Range("A1").Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlUp).Select Selection.End(xlDown).Select ActiveCell.Offset(0, 1).Range("A1:B1").Select Range(Selection, Selection.End(xlDown)).Select ActiveCell.Offset(0, -1).Range("A1:C24").Select Charts.Add ActiveChart.ChartType = xlLineMarkers ActiveChart.Location Where:=xlLocationAsObject, Name:="Charts" With ActiveChart .HasTitle = False .Axes(xlCategory, xlPrimary).HasTitle = False .Axes(xlValue, xlPrimary).HasTitle = False End With End Sub
View Replies!
View Related
Arrays As Object Properties--VBA
After much online digging, and experimentation, I think I determined earlier that you can't really expose an array all-at-once if it is an object/class property, as you can with an array variable. Now I'd like to confirm this, if I could, because it would be neater to run my simulation in an object instead of a giant and labrynthine user-defined type. I try the following ....
View Replies!
View Related
Use VBA To Determine Object Closest To ActiveCell
I prefer to use the keyboard--rather than the mouse--as much as possible. To avoid having to use the mouse to select objects that I need in an Excel spreadsheet (like textboxes or charts), I'd like to write a macro that selects whatever object is "above" the activecell. This would allow me to select a textbox, for instance, simply by navingating the activecell (not cursor) to just underneath it and then executing the macro (from a hot-key combination, of course).
View Replies!
View Related
Vba : Error Returning Validation Object
I am trying to read Formula1 from the the Validation object. If the cell does not contain a Formula1 - I get on object error. In: http://www.ozgrid.com/forum/showthread.php?p=95521 Derk suggested "That error occurs when the activecell has no validation. Some of the properties return as "codes" so you will need to figure out what say -1 means for alertstyle." I do not know how to test for this.
View Replies!
View Related
VBA Filter ON I Want It Off
I am using Excel 2007 and am coping data from a temp entry form into a main entry form. The main entry form has filter ect. I have a macro that will copy the data in the temp form and pastes it in the fist available entry line. Problem is that if a filter is turned on it will paste over some of the data that is hidden by the filter. What is the code in 2007 Excel to turn off the filter that is on. I do not want to remove the filter, I just want the one that is on to "show all" again so I can paste the data.
View Replies!
View Related
Filter Range In VBA
I am using the following VBA code each month to filter some data, and then copy the filtered data to another worksheet. Can anyone please advise how I can copy and transfer the filtered data, as the number of rows in the filtered data will always differ. Sub FilterTo2Fields() With Sheet1 .AutoFilterMode = False With .Range("A1:E1") .AutoFilter .AutoFilter Field:=1, Criteria1:="Bingo" .AutoFilter Field:=4, Criteria1:="Sydney" End With End With End Sub
View Replies!
View Related
VBA Filter On Specifice Date
I am writing a simple macro and trying to filter on a specific date. I thought it would be as simple as this; Dim mydate As Date mydate = Range("r4") Range("A3:K3").Select Selection.AutoFilter Selection.AutoFilter Field:=7, Criteria1:=mydate, Operator:=xlAnd Range("A2").Select The filter doesn't seem to work as it doesn't return any results, even though there are results in the table.
View Replies!
View Related
Filter On Multiple Criteria Using VBA
I have a dataset, which I would like to sort on multiple criteria. The code I have is : Dim Lst As Long Dim Hdr As Range Lst = Range("A65536").End(xlUp).Row Set Hdr = Range("A6:AD" & Lst) With Hdr .AutoFilter .AutoFilter Field:=9, Criteria1:="Complete" 'Match Status .AutoFilter Field:=14, Criteria1:=Array ("Pending", "Technical", "PR", "Regional", "=") 'Case Study Status End With Field 9 Match Status will always be Criteria "Complete" Field 14 may contain different variables depending on the dataset. I want the filter to bring back all Match Statuses (Field 9) "Complete" and multiple Case Study Statuses in Field 14. This code filters correctly on Field 9, but is only bringing back blank cells in Field 9 when there is data that has Case Study Status "Pending", "Regional" and "Blank".
View Replies!
View Related
VBA Macro To Filter And Sort
I'm tryin to set up a macro to filter and sort and when I record the macro correctly it does not run properly. I have detailed info below: I created a sheet "Met Logbook" which contains all links to the source "Master Logbook". This master logbook has a lot of info added daily and we add info at the top of the sheet (we insert new rows every time at the top for different reasons). So what happens is the master logbook always changes its cells (when inserting new rows at the top, all the cells change row number). So I have just linked all the cells and more that we may be using in the Met logbook. This is why I need to filter and then sort the Met logbook (since there will be so many blanks, unuseful info and in the wrong order). (It will be in the wrong order because the "master logbook" has newer info at the top and I have more than one sheet of info for the master logbook) (so my links in the met logbook are somewhat out of order). So what I need is to have code to filter column B with: and column H with "Blanks", then I need to sort column A (rec'd) in descending order (so that newer info will be at the top). I will post my Met Logbook sheet on my second post since its a little large.
View Replies!
View Related
AutoFilter VBA To Filter Different Ranges
If I had a table of data (say in range A5:D15) and then I autofiltered that table in vba with... range("A5:D15"). autofilter Is there any way that I can change the positioning of the autofilter drop down arrows, to row 1 say, rather than the usual row 5 (the top of the table)?
View Replies!
View Related
Sum And Filter VBA Code
I got a job in hand and do not know how to solve. 1. Part of the problem I have a table that is exported to excel from a program, and this table is always different sizes so I really need a VBA code. In column F i need to have the difference between the values in column G and column C Ex: G1 - C1 = Goes to M1 G2 - C2 = Goes to M2 and so on 2. Part of the problem With the values in column M and column L. I need the sum of all column values in Column M where L is the value of 2. These data are to Sheet2 - cell A1
View Replies!
View Related
Filter New Database Query In VBA
I am trying to create a macro that will import data from an external database; however, I want to be able to filter the data using input from the end user. The code will work fine if I do not use a variable (i.e. I type "31" to replace the second instance of "Reply" below). Dim Reply As Integer Reply = InputBox("Week Number", " Find Week") ActiveWorkbook. Sheets("RawData").Select With ActiveSheet.QueryTables.Add(Connection:= _ "ODBC;DSN=DataWarehouse;Description=DataWarehouse;UID=DataWarehouse;PWD=;APP=Microsoft Query;WSID=WILLIAM;DATABASE=tmd" _ , Destination:=Sheets("RawData"). Range("A1")) .CommandText = Array( _ "SELECT vOEEDownTime. , " & Chr(13) & "" & Chr(10) & "FROM tmd.dbo.vO" _ , "EEDownTime vOEEDownTime" & Chr(13) & "" & Chr(10) & "WHERE (vOEEDownTime.downtimecode Is Not Null) And (vOEEDownTime.weekbucket = Reply)") .Name = "Query from DataWarehouse"
View Replies!
View Related
Advanced Filter Vba - Workbook Name
I created an advanced filter macro which analyzes the "Orig_Appmt_Data" dataset from the "Summary" worksheet and provides the resulting analysis on the "Effective Rate" worksheet. However, when I change the name of the workbook, the macro fails. I was hoping someone could provide some assistance in helping adjust the vba code to take into account the subsequent changes in workbook filename. Here is the Sub ER_Analysis() ' Range("B8:R109").Select Selection.ClearContents Columns("P:R").Select Selection.EntireColumn.Hidden = False Range("Q5").Select Range(" Conversion 3-28-07.xls'!Orig_Appmt_Data"). _ AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("Q5:Q6"), _ CopyToRange:=Range("B8:R8"), Unique:=False Range("B8:R8").Select Selection.AutoFilter Range("B8:R87").Sort Key1:=Range("P8"), Order1:=xlDescending, Header:= _ xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Selection.AutoFilter Field:=1, Criteria1:="<>", Criteria2:="<> TOTAL" Columns("Q:Q").Select Selection.EntireColumn.Hidden = True Columns("P:P").Select Selection.Font.Bold = True Range("P8").Select End Sub
View Replies!
View Related
Automate Advanced Filter With VBA
I need to lookup and concatenate all the header values where the value in the corresponding row equals a certain value. For example, column D, has the column header value if the cell values equals "X". Likewise column E has the column header value if the cell values equals "Y". I have too many columns (this is just a simplified version) to use nested if statements. resource1resource2resource3 XResources YResources Jeff X resource2 John X X resource2 resource3 Jim Y resource1 I'm not an excel newbie, but I keep thinking there must be a simple solution that I am missing.
View Replies!
View Related
424 Object Required Error With VBA & Windows Media Player
I'm having some trouble with some VBA code written for Excel (Office 2003). I have a video file (in .wmv format) and a list of time stamps in an excel file. When I click a timestamp, I want to pop open the WMV and play it at that given time. I've made some headway thanks to a few others, but I'm getting this "Run-time '424': Object required" error that I can't seem to fix. I've attached the file, and it occurs at the line "frmPlayer.Show" and I have no idea why!
View Replies!
View Related
Looping Through Auto Filter Data - VBA
I have column A containing either "Correct" or "Incorrect". I have another column D which also contain same values "Correct" or "Incorrect". I applied auto filer on Column D , criteria is "Incorrect" and on Column A criteria is "Correct". All the above is done using VBA. Now, I want a code to convert the value in column A from "Correct" to "Incorrect", only for the rows retured by auto filter.
View Replies!
View Related
Get Unique Records Using Advanced Filter From VBA
i need to use the advance filter=>unique records only feature from my macro... how would i do tat? i have 3 columns... column A has records which are repeated... column B and column C's values for a corresponding column A's value are the same... A B C a 3 6 b 4 7 c 8 9 d 1 2 a 3 6 b 4 7 .... and so on... i need to use tat feature so tat i can filter column A alone and then copy column A, column B and column C's value to columns E,F and G...
View Replies!
View Related
Unique List Without Vba Or Advanced Filter
I have a list of item numbers that will be repeated numerous times. I would like to extract a list of unique values that would update when a new number is added. I would really like to do this with formulas. Both of the list will be on the same sheet. I have racked my brain trying to figure out a way to do this. I thought I could use LOOKUP and MAX for the first cell, and then subtract one from the number above for the following LOOKUP formulas. That did not work. Probably because my list is not sorted.
View Replies!
View Related
Using A Macro/VBA To Automate Filter Selection
I've recorded a macro which selects "1" in a filter drop-down box then prints some pages, then comes back and selects "2" in the filter then prints some pages, etc etc etc. I've looked at the code for this and it treats the "1", and the "2" etc as text each time - originally I had the filter on names, but the names change each time I need to do this whilst the process doesn't, so I filtered on numbers instead. However, I would have to enter the repeated blocks of code down to 1000 to get it to select down to "1000" in the filter. About 3/4 lines each time but with me manually typing in 1, 2, 3, 4 .... 999, 1000. Is there a way to say in VBA 'repeat filter selection until you've run out of numbers then come back to "All" and stop ?
View Replies!
View Related
VBA - Filter On Next Line In Autofilter Dropdown List
if anyone knows some VBA code to filter on the next line down in an autofilter list. My spreadsheet has a column with the names of people, which can appear multiple times in no particular order. I have a macro that I run several times -- once for each individual in the column. The way that I currently do this is by manually using the autofilter on that column to select a person from the autofilter dropdown list. After I've manually filtered on a person, I click a button which runs the assigned macro. I then manually select the next person in the autofilter list, and click the macro button -- over and over until I've done this for everyone in the autofilter list. I'd like to add some code at the end of my macro so that the macro ends by automatically filtering on the next person (line) in the autofilter list.
View Replies!
View Related
VBA For Filter To Hide Colums & Rows
I have a parts index containing 500+ rows of data, I also have multiple columns in which I can sort the data. I would like to have a button fixed in cell C4, D4, E4, etc... row 4 is the header, that when clicked, will filter all rows that have a selection (non-blanks) for only that column. So If I have data in various rows & column (C5:F500) that when I click on the button in cell D4, only the data listed in the various rows of D5:D500 are shown and columns C, E & F are hidden. Clicking cell D4 will show all data. I can create the button so that it is sized specific to the cell and follows the cell sizing and I can create a button to filter only columns D or E or F, etc... but that means that each button is a separate VBA, macro. A while ago I found a VBA code that allowed me to sort rows Asending/Desending depending on which button in which column was clicked... See inset: and this allowed me to add columns without changing the code. So I think If I can modify this code this will work great for me.. Sub SortTable() 'code written by Dave Peterson 2005-10-22 '2006-08-06 updated to accommodate hidden or filtered rows Dim myTable As Range Dim myColToSort As Long Dim curWks As Worksheet Dim mySortOrder As Long Dim FirstRow As Long Dim TopRow As Long Dim LastRow As Long Dim iCol As Integer Dim strCol As String Dim rng As Range Dim rngF As Range
View Replies!
View Related
VBA Code To Filter Listbox As You Type In A Textbox
I have a list of customers in listbox1 (the text values of which come from a spreadsheet), that I want to refine as I type in textbox1. I'm not sure if it's possilbe, but I would like it to work similar to the itunes search (if you're familiar with it) where it searchs for any occurance of the text within the list as opposed to just searching for the letters at the beginning of the word.
View Replies!
View Related
VBA To Manipulate Pivot Table Report Filter
I have a pivot table created from a data table with three columns: Date, Sales, and Customers. I have the Date column in the Report Filter and I want to change the date based upon a value in a cell range named Date, of all things. The pivot table is located in another worksheet and the range Date is changed by a spin button in the active worksheet. My code is: Sub ptDate() Dim pt As PivotTable Set pt = Worksheets("Pivot Tables").PivotTables("PivotTable1") pt.PivotFields("Date").ClearAllFilters pt.PivotFields("Date").CurrentPage = Range("Date") End Sub
View Replies!
View Related
Object Library Invalid Or Contains References To Object Definitions
I'm getting the following error: "Object library invalid or contains references to object definitions that could not be found" I wasn't getting that error last night and I'm not sure what I may have done to cause this error. It seems to be cause by code running on one sheet of my workbook, but I'm not really sure about that. I'm still a bit of a novice at VBA. I'm using Excel 2002 SP3 and I'm running MS XP Home as my OS. Do you have any ideas what can cause this error and/or how to trace down the offending objects/code?
View Replies!
View Related
Creating A VBA Chart
I have wriiten some simple code to create a chart which works fine. I have a problem applying formatting to my chart. I am using the With construct to apply the formatting, but the problem is that the chart name keeps on incrementing from "Chart 1" to Chart 23" etc. each time I run the chart and I get an error message before the With code?
View Replies!
View Related
Generate A Chart With VBA
I am working in a Lotus notes application that enables me to add an Excel report and chart. I have no problem adding a report using their template creater. however it says for me to add a chart I have to create an excel template that must contain the vbscript needed to generate a chart. I tried using the macro editor to create the report but i get an error "Microsoft Excel Select method of range failed".
View Replies!
View Related
Xy Chart In Vba, Order Of X And Y
I need to create many XY charts in a VBA macro. For each chart, I need to select a particular column for the X dimension, and a particular column for the Y dimension. When I use a named range to define the X and Y columns, my macro works fine for those instances when the X comes first. However, if my desired Y dimension comes first, I cannot find a way to correctly select these. The context is such that my spreadsheet always has the same data fields in the same columns, but the numbers of rows vary. In addition, I need to dynamically select which rows to use, based on the values in the columns to be plotted. Ive figured out how to do this within the macro, except for those instances when the Y column comes before the X. An example when this works: ' X-Y chart, Field10 vs. Field12 Sheets("Raw").Select Names.Add Name:="newRange", RefersTo:="=$K13" & ":" & "$K" & FirstBias _ & ",$M13" & ":" & "$M" & FirstBias, Visible:=True Range("K1").Activate Charts.Add ActiveChart.ChartType = xlXYScatterLines ActiveChart.SetSourceData Source:=Sheets("Raw").Range("newRange"), PlotBy:=xlColumns ActiveChart.Location Where:=xlLocationAsNewSheet, Name:="Field10vsField12" With ActiveChart .HasTitle = True .ChartTitle.Characters.Text = "Field10 vs. Field12" .Axes(xlCategory, xlPrimary).HasTitle = True .Axes(xlCategory, xlPrimary).AxisTitle.Characters.Text = "Field10" .Axes(xlValue, xlPrimary).HasTitle = True .Axes(xlValue, xlPrimary).AxisTitle.Characters.Text = "Field12" End With ActiveChart.HasLegend = False In the above example, variable FirstBias is computed previously in the macro. I realize that I can rearrange columns in my spreadsheet to avoid this, but that is much less convenient, and less elegant, and I think there must be a way for a macro to do this automatically. I can do it interactively by cutting and pasting the data ranges in the chart wizard dialog, but I need this to be automated. I also figured out how to automate it in the case where the X and Y columns have fixed rows, by adding the commands below:....................
View Replies!
View Related
VBA Chart Title Difficulties
I have a pivot table which I update on a regular basis. There's also routine during the pivot table refresh to assign variables to the minimum and maximum dates I include in the range. Here's what I'm looking for - The chart title needs to be two separate lines. It should look something like this: Labor Operations performed from min_date to max_date (labor op code, description, total ops) By themselves, I have no problem doing this. What I can't figure out is how to format the font of the first line of the title to have different characteristics from the second line. The second line is sort of a descriptor of the part in bold (in an attempt to keep my boss from asking me questions about what he's looking at)
View Replies!
View Related
Chart VBA Coloring Lines
I have this code that colors the lines in my Line Chart Sub ColorLines() Application.ScreenUpdating = False Set chrt = ActiveChart 'Here you want to put your own graph vals = chrt.SeriesCollection(1).Values 'These are the values to determine later whether the line moves up or down. In this example, I just colored 1 seriescollection (= one line in your line graph), with an extra loop you'd do all lines. It is very simple: When the lines goes up they turn black. When they go down they turn red. The code work, but only if all cell in the series is filled. If one cells is blank the code error. I'm using #NA() in all cells that are blank, so the chart skip that cell and continue from the next cell's value.
View Replies!
View Related
Changing Chart Source With Vba
I'm trying to create a chart with different source ranges e.g if i used With ch.Chart .SeriesCollection.Add _ Source:=Worksheets(1).Source:=Worksheets(1).Range("C1:C8,J1:J8") End With That works fine but I want to modify the columns it looks at. I was going to use the cells(x,y) method but I can't get it to work. icol = 3. Range(Cells(1, iCol), Cells(8, iCol)). This works for a single range(C1:C8), but how do i reference Range("C1:C8,J1:J8") in the same way.
View Replies!
View Related
VBA Macro To Filter Rows By Cell Value & Hide Blank Columns
i have created a spreadsheet to simplify our work flow, I am stuck on what is probably the easiest of the commands. basically have rows dedicated to specific codes and the colums represent values relating to each code, all codes have a different set of values, the attached example only has a few variables but the actual worksheet will have several hundred. the idea is the user will input the code they wish to get details on in A2 and then press the command button and it will then show (as per the after sheet in the attachment) just the relevant information for that code, so filter the code in column A and hide the columns which hold no value. where i am getting stuck is I am not sure the best way to proceed, is it best to create the macro button to do the filter and hide or is there a better way using vlookup and a pop up window asking for the relevantcode to be inputted to to retrive the information, again understand there will be hundreds of colums and hundreds of rows and the values may be 20 or 30 colums apart for some of the Codes so this simplification is really saving the user a lot of time.
View Replies!
View Related
Manipulating Chart Source Data With VBA
I have a chart that I am trying to set up with dynamic data. I have the chart created, but the problem is that I will have a variable number of categories based on the data that is loaded, so I need to use VBA to change the range for the source data and labels on the fly (otherwise, I will end up with 20-50 categories that are all zeroes, putting a bunch of gobbledegook at the top of the chart). What commands to I need to enter into VBA to get this to work? I have put a formula in 2 cells to determine based on the current data what the source data values range should be, and what the category labels range should be. The cell that holds the value range is Graphics!L6, and the cell that holds the labels range is Graphics!L7. The current values that these cells hold are: L6: =Graphics!$J6:$J9 L7: =Graphics!$K6:$K9 Oh, and the name of the chart is "Chart 1" What do I need to put into VBA to get the chart to change the data source values and category labels to the ranges I have listed in those 2 cells? (and for that matter, have I listed the ranges correctly in those 2 cells so that they are usable?) If possible, I would prefer to do this without having to use code to select the chart, because I want the updates to the chart to be invisible to the user.
View Replies!
View Related
Changing Chart Series Colours In VBA
I have a spreadsheet which reports across different categories, but there's a lot of info. So simplify this, I've written a simple macro that changes the series range in an existing chart, so top level and by category. This works well apart from I'm using excel 2007, and some people aren't, so the default colours look fine on my version, but change to some awful colours on anyone with an earlier version of excel. I need a way of changing the colours to standard ones depending on which macro is being run. I have tried running the following, but I get an error, basically saying the series hasn't been selected. ActiveSheet.ChartObjects("Chart 6").Activate ActiveChart.SeriesCollection(3).Select ActiveChart.SeriesCollection(3).Interior.Color = RGB(255, 0, 0)
View Replies!
View Related
Vba - Chart To Align Data Required
I am a PhD student and have a series of coordinates for various DNA sequences. I need to generate an excel chart which will show all the sequences aligned one on top of the other, not like a stacked bar, but where no gaps are found between the bars. So that they appear as if they have fallen down as you would see with Tetris. This would end up with a bell shaped chart, rather than a messy chart. I need to do this to demonstrate which sections of the entire sequence appear more often. Can this be done using VBA or is there a way to modify a chart? I have no previous experience using VBA so I'm close to pulling my hair out.
View Replies!
View Related
Vba Chart Axes Editing Syntax
my VBA code does some simple editing. Something I would like it to do is make the x-axis and y-axis lines be editable. What I mean is say for editing the Plot area background you would use this ActiveChart.PlotArea.Format.Line.ForeColor.RGB = RGB(0, 0, 0) I am looking for the equivalent to do the x and y axis lines.
View Replies!
View Related
VBA Color Cells For Gannt Chart
I have been struggling for some time to find a simple code to color index cells that have two conditions, one being the task owner and the second being the time requirement. I have a drop down list for populating each row of a gannt chart with the owner, this owner also has an associated number referencing the allocated colour index number. To the right of the owner is a basic time line with each column represneting days, weeks or whatever measurement. These columns are populated simply with an "x". What I want to do is to choose the owner, go across to the time, type in an "x" in the time slots and the cells with an "x" are coloured with the relevant owners colr index. I have researched the threads, read my text books, looked up the help and found a lot of references which are around the solution but none which nail it. Looking forward to your assistance.
View Replies!
View Related
Auto Chart Positioning By VBA Or Other Settings
i try to change the chart position (chart properties) to make it auto- move to empty cells, but anyway i fail. say example:- i have a excel sheet, Worksheet 1 ------------ raw data, all records. worksheet 2 ------------- 1 pivot table + a graph/chart at the same sheet. top area of worksheet is pivot table, below is chart. The pivot table size can be change from time to time (by increasing the records at the worksheet 1) settings or using vba to control it? by auto move the chart position down, and not overlap with the pivot table.
View Replies!
View Related
|
TRACKER
