Chart Value Changes in VBA

When you have say a bar chart and drag the bar downwards this will change
the value in the reference source cell. Is there a way through VBA to
identify the source and the cell changed by when dragging the bar. That is,
when you drag the bar in the chart let me know the cell that ahs changed!

Any help would be appreciated. Thanks in advance.

Howard


0
jj933 (5)
12/3/2003 5:12:14 PM
excel 39879 articles. 2 followers. Follow

1 Replies
494 Views

Similar Articles

[PageSpeed] 55

John,

If your objective is to prevent the cell changes via the chart, you can
protect the worksheet (Tools - Protection).  The cells should be locked
(Format - Cells - Protection).

Or you can use the Chart_SeriesChange event macro for the chart sheet.  It
will tell you which series, and which point of that series was changed.
From that, you can determine the cell affected, per the chart's source data
references.

-- 
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"John" <jj@hotmail.com> wrote in message
news:O$bjoCcuDHA.3116@tk2msftngp13.phx.gbl...
> When you have say a bar chart and drag the bar downwards this will change
> the value in the reference source cell. Is there a way through VBA to
> identify the source and the cell changed by when dragging the bar. That
is,
> when you drag the bar in the chart let me know the cell that ahs changed!
>
> Any help would be appreciated. Thanks in advance.
>
> Howard
>
>


0
nowhere8060 (363)
12/5/2003 2:54:03 AM
Reply:

Similar Artilces:

Trying to change txt color from message map function
HI, My menu has a option that changes the text color. so I have my OnPaint() function but I am trying to call the DC from another function in same class.. what am I doing wrong? void CChildView::OnTextBlack() { // TODO: Add your command handler code here CDC* pDC = GetDC(); pDC->SetTextColor(RGB(0,0,0)); pDC->TextOut(mPt.x, mPt.y, mStr); ReleaseDC(pDC); mCount = 1; Invalidate(); } I changed my approach to ON_COMMAND_RANGE... and came up with this... it worked... but why not the first code? void CChildView::OnTextColor(UINT nID) { CClientDC dc(this); switch(nID) { ca...

Office Chart doubt
Hi, I try to create a chart using Office Chart Component 9. I set the type of the WCChart object as chChartTypeScatterLine, WCSeries object1 as chChartTypeScatterSmoothLineMarkers. WCSeries object2 as chChartTypeScatterSmoothLine. But the type applied to series 2 is always set to series object 1. void CImageCalibChartCtrl::ChangeType() { CWCCharts aCharts = myChartCollection.GetCharts(); CWCChart aChart = aCharts.GetItem(COleVariant((short)0)); aChart.Select(); aChart.GetSeriesCollection().GetItem(...

Need to Change Column of Telephone numbers to just 10 characters
Hi I imported data from another program into excel. The telephone numbers are in the following format 333 333-3333. How do I change it to just having 10 digits without spaces of hyhens. I need it in this format to export to another system Jen Edit>replace find what -, leave replace with blank, then replace again and this time put a space in the find what and replace with nothing -- Regards, Peo Sjoblom "Jennifer Leen" <anonymous@discussions.microsoft.com> wrote in message news:7923E5C4-B199-464F-B34D-9B3B2C726376@microsoft.com... > Hi , > > I imported d...

How do I print 2 charts to 1 page?
Hi Cloudy Maybe http://www.rondebruin.nl/print.htm#non-contiguous -- Regards Ron de Bruin http://www.rondebruin.nl "Cloudy Amie" <Cloudy Amie@discussions.microsoft.com> wrote in message news:B9890E25-B186-4140-B829-AEF7EB1ED109@microsoft.com... > ...

Counting spefic cell (not a range) with a value greater than 1
I am looking for a formula to count specific cells and a range (A5, A10, A15, A20 and so on) but only count when the value is greater than $1.00. So if the value of cell A5 was $1.50, the value of cell A10 was $1.25, the value of cell A15 was $0.50 and the value of cell A20 was $2.00 the total count would be 3. I'm stumped! =SUMPRODUCT(--(LARGE((A5,A10,A15,A20,A25),ROW(INDIRECT("1:"&COUNT(A5,A10,A15,A20,A25))))>1)) however if you want to sum every 5th cell greater than 1 you can use =SUMPRODUCT(--(MOD(ROW(A5:A50),5)=0),--(A5:A50>1)) -- Regards, Peo Sjoblo...

how to change from mayusc to minusc?
Hi there, I need help on how to change for mayusc to minusc on excell 2007. many thanks!!! Tienes que preguntar: How do I change from Upper to Lower case. "Ivo - Spain" wrote: > Hi there, > I need help on how to change for mayusc to minusc on excell 2007. > many thanks!!! Yo no se mucho de Excel, pero no dudo que sea igual que Word, toca la tecla "Caps Lock" que es la que cambia de may. a minus. y viceversa. "Ivo - Spain" wrote: > Hi there, > I need help on how to change for mayusc to minusc on excell 2007. > many th...

Change Data Connection Definitions from local to sharepoint
Hi, I am using Excel 2007 and have created a query tool/workbook that contains a linked table worksheet from sharepoint as the source data (its a custom view/subset of the records data). This worksheet is refreshed from the sharepoint source periodically. I created this tool/workbook on my desktop, and now want to put it on the sharepoint location for multiple users. However, the Data Connection definition for the linked worksheet is showing the local address of my pc, so the data refresh won't work once the workbook is posted to the sharepoint. I have not been able t...

Change Directory Name in Exchange 2003, Windows Server 2003
The directory name that appears in exmerge does not match the user account name and I would like to know how to change it. Another administrator created an account in Exchange 2003. The display name is Jane Smith, the login is jane@domain.org and the e-mail is janes@vera.org. When the account was created, the word test was put in one of those fields (which one I am no longer sure and it was changed after creation to the names above, although test@domain.org is still one of the e-mails for this user but not the default). When I use exmerge the directory name that appears for the accou...

Pivot Chart, line graph w/ multiple series
I have columns of cust, year, est sales, actual sales. Customer is put in page area, year is put on category axis. I can add est sales to data area and will have one line. But when I add the actual sales to the data area, it does not show as a line, but adds itself to the category x axis. Am I missing something? If you are adding the field directly on to the PivotChart, consider using the associated PivotTable. Is the 'actual sales' column part of the data field or one of the the row/column fields? Ensure it is a data field. -- Regards, Tushar Mehta, MS MVP -- Excel ww...

Chart does not show up in print preview and wont print?
I have chart that is a workbook page but when I select print preview it does not shown up, only a blank pages comes up. And so it wont print. How can I fix this? I have Office 2007 and I can not select set print area or clear print area, they are shaded out. ...

Change Row Fill Color
I'm having a problem that I'm pretty sure can only be resolved with some type of Macro. I would like to know if it is possible to change the fill color of an entire row when text is entered in a specific cell within that row. For example. When "Not Received" is entered in cell C3, I would like all of row 3 to be filled with light blue. If something else is entered in that same cell (e.g. "Received"), I do not want the fill color to change at all. I know it's possible to change a single cell this way using Conditional Formatting, but how do you apply...

Pie Charts
Hey guys..I am having trouble with the auto formats on excel charts. Specifically, when I make a pie chart the size and wording are not properly spaced. Every time the information changes I have to manually realign everything. Does anyone know how to make it so it everything fits automatically. Thanks again. CHip ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements ...

Changing PORT of Default CRM Site
I recently installed 3.0 and installed it in the Default web site, which is obviously Port 80. I did some port forwarding in my firewall to make it acccessible from the outside of our network and need to change the Port. I changed it in IIS but evidently there is another location that also needs changing, as the CRM errors when trying to load data. Any ideas or suggestions? Thanks Hi Stan, In the registry, HKLM\software\microsoft\mscrm "Stan" <Stan@discussions.microsoft.com> wrote in message news:BD5A13DB-58AE-4A11-82A4-DEA25B89C966@microsoft.com... >I recent...

At each change in data apply formula
Is there a function/ code that can look down a column and apply a formula when there is a change in data. i know there is the subtotal function but this does not work for my requirement. Using the following data I would want to automatically look at where the data changes (in column A) and apply a formula in another column (say Column B) for the same row. I would therefore expect to apply the formula as per the following example to cells B1, B4, B5 and B9 Col A row 1 AAA row 2 AAA row 3 AAA row4 BBB row5 CCC row6 CCC ro...

Bar Chart #9
I have a spreadsheet like below and I want to make separate (but the same format) bar charts for each week The top-left cell starts at cell A1 (The numbers below are hours) This is a spreadsheet to log the amount of hours lost in the department and the reason why productivity was delayed for that time. Date Server Printer Temperature Network Data Control 4/28/08 4 4/29/08 5 4/30/08 5/1/08 1 5/2/08 3 Totals 4 8 1 5/4/...

Impact of changing database column width?
Hi, We are a software product company and are planning to begin using the Contract Administration module. To do so, we will be switching our inventory items from Track: None to Track: Serial Numbers and we will be storing our software license keys in the Serial Number field which is column SERLTNUM in table SOP10201. Unfortunately, SERLTNUM is CHAR(21) and our license keys are a few characters wider than 21. We can get the keys down to 21 characters by removing three embedded hyphens, but there are several databases outside of GP where the license keys must still exist with...

CRM 1.2 and Change Domain
Hi, I know Microsoft CRM is tightly integrated to Active Directory and Windows Domains. However, we've been acquired by another company to which we need to merge our systems to their AD. Our CRM has a lot of data and our current Windows domain should go after every systems are migrated. Does anyone ever tried a domain migration with a Microsoft CRM installed ? Do we need to export everything and then reimport everything? Thanks for your help! Sylvain Belanger Well, I would definately make sure you do a complete backup prior to doing anything. Depending on how they merge the Forests...

Making legend (or textbox) move as data changes
Hi I'm trying to make an XY scatter chart which my users will be able to change, just by changing the data in the data ranges. The chart contains several curves each having its own legend/text box, placed at the right end point of the curve. When the data changes, I need the legend/textbox to move along with the end point of the curve (colors and different line styles are not an option). I have tried to group the curve with the legend/textbox but it doesn't seem to work. Any ideas? mr Hi, Maybe these examples will help. http://peltiertech.com/Excel/Charts/LabelLastPoint.html h...

Milestone Slip Chart Example
I am trying to create a milestone slip chart in EXCEL to track status o my project outside of our project planning and managemet tool. Doe anyone have an example of something they already use? Any help woul be greatly appreciated. Pet -- Message posted from http://www.ExcelForum.com ...

Page format changes when document is shared
I have an Excel document that was created by someone else. I saved it and shared it. When printing, the page format is different for others than it is for me. Also, the page format changes for those users if I turn the "save" function off. How can I get the page format to be the same for each user. Everyone is using the same version of Excel. ...

Year series shows wrong in chart
Hi all : using Excel 2003, I have what should not even be a problem that I cannot solve. I have a series of years in a column, 1970-2006 to be exact, and these are the labels for my x axis. When I insert chart this appears as 1,2,3,...instead of 1970, 1971, etc. It doesn't matter how I format that column, text, general, custom, nothing works. Why is it not just giving me the data in the format that is actually there and how can I get it? thanks for any help Bevin B. Try first entering the dates as dates. To check to make sure they're entered as dates, after entering the data c...

why won't excel allow me to add more data to a chart?
For some of my data I skip days for collecting it so I use the shift key to click on the days I do want in the chart. I have been doing this for awhile but now that I'm obtaining more points it has simply stopped letting me add data points. When I click on the one where it stops collecting it erases all of the others I have clicked and makes a stop noise. I need to add more data so why won't it let me?? Hi, There is a finite limit on the length of the series formula, ~1024 characters. So this example is for a series with 3 data points in cells A2:B4. =SERIES(,Sheet...

Vertical line in chart
Hi, I create a line chart with three different lines. The x- axis is used to show the status of items over a number of weeks (planned, revised, finished). I wan to insert a vertical line in sheet, showing current week. Tips? On Jon Peltier's site, there are instructions for adding lines to a chart: http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine Konpego wrote: > I create a line chart with three different lines. The x- > axis is used to show the status of items over a number of > weeks (planned, revised, finished). I wan to insert a > vertical line in...

How-To: Select and Display Combo Box choice with VBA
How To: Using a value from another field I would like to display a certain selection in a combo box. For example if a user selects 'X' then I would like to display ITEM(3). What combo box properties/methods should I be using? Use after update event on the item where the user selects "X". "Stu" wrote: > How To: Using a value from another field I would like to display a certain > selection in a combo box. For example if a user selects 'X' then I would > like to display ITEM(3). What combo box properties/methods should I be using? My questi...

How to subtract data in one chart from another chart in access?
I have data from a query in one chart showing revenue totals from July2009 to December 2009. Then I have another chart showing revenue totals from July2009 to January 2010. I want to create a chart that shows revenue for only the month of January2010. This means I need to subtract the December2009 revenue from the January2010 revenue. Is there a query for this? Can you please post the structure of your tables? -- Lynn Trapp MCP, MOS, MCAS "Lanz" wrote: > I have data from a query in one chart showing revenue totals from July2009 to > December 2009. The...