How can I create and display a chart dynamically on a UserForm wi.

I am trying to create charts dynamically using VBA and Excel. The data being 
plotted will change frequently, and my client wants to interface only with 
the user form, and not the worksheet itself. I know that you can use the 
MSChart control to do this in VB6, but I was wondering if there is a similar 
control for use with Excel and VBA. If so, any additional info on how to use 
it would be much appreciated. Thanks.
CC (39)
2/14/2005 11:33:02 AM
excel.charting 18370 articles. 0 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 49

I think it's an incredibly dumb idea to want to interface only with a 
userform (and sacrifice the flexibility of direct access to a chart).  
Maybe, you can convince your client to work with a chart on its own 
sheet (rather than an embedded object in a worksheet).  But, if you 
must, see John Walkenbach's


Tushar Mehta
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <>, says...
> I am trying to create charts dynamically using VBA and Excel. The data being 
> plotted will change frequently, and my client wants to interface only with 
> the user form, and not the worksheet itself. I know that you can use the 
> MSChart control to do this in VB6, but I was wondering if there is a similar 
> control for use with Excel and VBA. If so, any additional info on how to use 
> it would be much appreciated. Thanks.
2/14/2005 2:44:07 PM

Similar Artilces:

Display a pix from a URL in a Excel cell
Hi; I have a CSV exported from a ecommerce web site that has the URL for the thumbnail pix of the products. I have this in Excel. It is a full qualified URL, i.e., . I just want to display the thumbnail in an excel cell, to product a printed output that has a pic of the product so my minimum wage inventory clerks can ID the product and do the count. Ought to be easy, but I can't figure out how to do it. -- Don Hi see your other post. Excel is probably not the right tool for this :-) -- Regards Frank Kabel Frankfurt, Germany P...

How can I rearrange the toolbars?
I've just now installed IE8 and I've checked the help files but am unable to find out how I can change to order of the toolbars. I am using RoboForm and I would really like to have it as the lowest toolbar. Any help greatly appreciated? Thanks, Lorraine ~~~~~~~~~~~~~~~~~~~~~~~~~ Customization in IE8: Customize fit your needs Many third-party toolbars have their own, ...

Is there a way I can only print the reply instead of the entire email message
I wonder if there is a way I can only print the reply to an email message, instead of printing the entire message? My choice for selection only seem to be gone with Outlook 2003 printing options. Any help is appreciated.............Peter ...

Old servers showing up in "Create an exchange mailbox" wizard.
Greetings, I have a customer who removed some Exchange 5.5 servers in an usual fashion, and as such I removed them from the ORG by using ADSIEDIT to delete them. The problem is these mailbox servers are still showing up as target options in the create a new mailbox selection wizard. How can I clear these dead and gone servers from this list? The SRS databases and ADC are long gone, and the enviornment is native mode 2003. Also I thought at one point making a server a front-end server made it not show up in this list. I see all their front-end servers in this list, so I am guess my recollectio...

How can I access a public calendar from a custom form
I am trying to create a custom form that would allow a employee to request a vactation time frame. This form would then be mailed to a supervisor who could approve or disapprove the request. I am having difficulty getting the response posted to a public calendar vs. the managers private calendar. Help! -Jeff ...

Can a macro open another worksheet?
Hello, I've got a macro that I need to run on about 200 spreadsheets. Is there a way to get it to select and open all 200 spreadsheets? Thanks, Art. Are they all in the same folder? In fact, do you need to open all the workbooks in a folder? Or all the workbooks in multiple known folders? If you have files in one folder--but you want to choose (click on the first and ctrl-click on subsequent in the file|open dialog), you can do something like: Option Explicit Sub testme() Dim myFileNames As Variant Dim iCtr As Long Dim wkbk As Workbook myFileNames = Ap...

How do I use excel names with INDIRECT with charts
Hello, I want to create a Chart that does not directly reference cell-ranges (i.e. A1:A6), but excel-names that make the reference sheet-independent. My aim is to be able to copy one chart to other worksheets, which have their dataareas at the same places like the source-sheet. Problem: This works fine in cells but not in charts Excel name definition: =INDIRECT("R3C2";0):INDIRECT("R3C5";0) Any idea about this? Thanks in advance, Holger. You have to include the sheet name in the final formula that you want XL to use. -- Regards, Tushar Mehta

Can i display an Icon on a toolbar?
Hello, I'm building a toolbar but i do not want to manualy draw the buttons. Instead i want to be able to display prebuilt ICONs there. Can this be done? How do i proceed? Many thanks You should be able to do it by simply adding a CStatic on the toolbar and placing bitmap/icon on it. Following article shows how to add controls to the toolbar: ------------------ Ajay Kalra "Bredal Jensen" <> wrote in message news:<eMRs7FziEHA.636@TK...

can someone explain what the icons mean
I have a question about the icons next to the email headings. for instance what does the little "i" mean next to the envelope that means it has tracking info attached. See -- Diane Poremsky [MVP - Outlook] Outlook Tips: Outlook & Exchange Solutions Center: Outlook Tips by email: EMO - a weekly newsletter about Outlook and Exchange: EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM You can access this newsgroup by visit...

Line Chart #13
Hi, The following is my data and I need to chart this. Is it possible to have a range in one cell? Thanks for your help in advance Experience (Years) Large Medium Small 1 $90,000-$100,000 $75,000-90,000 $65,000-78,000 2 $92,000-100,000 $80,000-95,000 $75,000-85,000 3 $105,000-130,000 $90,000-100,000 $85,000-95,000 4 $117,000-150,000 $100,000-115,000 $90,000-110,000 5 $140,000-170,000 $115,000-130,000 $100,000+ 6 $140,000-190,000 $135,000+ $100,000+ 7 $170,000-250,000 $135,000+ $110,000+ ...

Refresh pivot chart when info in a cell changes
To all, I am looking for help with a Macro. What I ultimately want to do is refresh a pivot chart when the user makes a selection from a list (in a data validation cell). For example, I am an end user that selects my territory from a "drop down". The pivot chart will update to the information that is directly related to my territory. Thanks in advance for your help. Excel 2007, PivotTable With Table dependent drop-downs instead of data validation drop-downs. With non-event-driven macros. ...

can cvs files be opened using excel viewer
i have a user who cannot open cvs files with excel viewer but can ope with the full version of excel...anyone experienced this problem and i so, can you pls post the resolution -- darrie ----------------------------------------------------------------------- darriel's Profile: View this thread: There is nothing in the description of the Excel Viewer to suggest that it can read anything other than true XLS files.;...

Any suggestions on how to create a simple monogram?
I'm trying to create a simple monogram, and was hoping for some suggestions. Any hints would be appreciated. Thanks. Probably WordArt if you are using Publisher. There are lots of alphabets on the ClipArt site. You can ungroup them and manipulate the letters into a monogram. What initials are you using? -- Mary Sauer MS MVP news:// "cmarnett" <> wrote in message news:91315A55-2E5A-4151-8D3D-54F94785A3E4@...

Display value of cell
Using Excel 2000 In a cell the formula shows instead of the value/result, how do I correct this? I want to see the formula. Reply to Thanks. Are all formulas cells show the formulas or just one? Maybe you have a space before the = (Excel think it is text now) Or your cell is format as text -- Regards Ron de Bruin (Win XP Pro SP-1 XL2002 SP-2) "Kenya" <> wrote in message news:050b01c3942b$e28b7240$a301280a@phx.gbl... > Using Excel 2000 > In a cell the formula shows instead of the value/resul...

data labels in charts
This is a probably one of the simplest questions but I'm just starting to chart again. I have entered a category title "year" in cell A1 and entered from 1995 to 2000 from A2 to A7 that I want to appear on the horizontal axis. I have entered a title in B1(unemployed) and 5 values B2 to B7 directly below. When I choose a "column" chart my vertical axis appears correctly but the horizontal axis does not include the years as labels. The labels that appear are the numbers 1 to 6 instead of 1995 to 2000. How do I make the chart pick up the data labels from colu...

Creating a basic phone followup
I am very new to this CRM product. I have set up a letter campaign to a small group of potential customers and I'd like to create a phone call tracking list for my phone follow ups. What is the quickest/best way to achieve this? ...

Can I switch axes in a Worksheet?
Can I switch axes in a Worksheet? It was easier to enter data in the current setup but now it may be easier to analyze the data if I can switch the axes. Can it be done?? Again, I would just like to switch the x and y axes in the worksheet... Amy wrote: > Can I switch axes in a Worksheet? It was easier to enter > data in the current setup but now it may be easier to > analyze the data if I can switch the axes. ... Select the data and use Edit >> Copy Then go to another worksheet and select a cell (like A:1). Then use Edit >> Paste special >> Tra...

Can't activate trial version
I just bought the trial version of Publisher 2003 and I can't get it to activate. I've uninstalled it and reinstalled it twice, double checking the Product Key on the folder, but it keeps telling me that it's an invalid number. And, of course, there's no "support" provided by Microsoft. This is VERY frustrating. Any suggestions? By the way, the "activate by telephone" option isn't available on the trial, so I can't even call them. HELP! I'm unsure what the exact issue is. Are you unable to complete the installation because the program...

Can't get out of selection? Assistance would be most appreciated...
Perhaps I have done something inadvertently. I am in an Excel workbook and I appear to be in the middle of selecting a block of cells. Everytime I move the cursor, the cell selection area changes. I can't Esc out, or use the Enter key. Mousing over the menu, the menu does not respond. Rather silly really, but I desperately need to use this workbook and nothing seems to function. Even when the cursor is moving over the menu items, the cells selected in the workbook area still seems to be changing. I can't use the menu - the arrow keys don't work. Does anyone know how to &quo...

Excel 2007 chart color change based on the label.
I have 12 charts 1 for each person and the data changes every week and some of the values have 0 so are filtered out. On the chart I want 0-15 to be blue, 16-30 to be light purple, 31-60 to be a cream color, 61-90 to be light blue, and 90+ to be dark purple. With the code below I can change the color if I take the if statement out but I would like to change the color based on the label. I have tried several things like .text, .name, and .label. I just can't fine the right name. Name1 0-15 1 61-90 1 90+ 3 Name 2 0-15 14 16-30 5 31-60 1 61-90 6 90+ 12 For i = 1 To A...

Combing Text with Ex. Field Name to Create A New Field Name....I Think?
Hello, I have a query that will return data from a table, and another query. Here is my question. This is an existing fuel database. It runs on a keylock system so there are keys numbered A1 to C10. The table returns a sum of fuel based on a key (for example A1). I have a set of fields from another existing query labelled DIFFA1, DIFFA2, etc. What I would like to do is return the value for "DIFFA1" when I am returning the information from Key A1. I would like to set up an expression something to the effect of: Expr1: "DIFF" & [Key] I did this and it returns the ...

Create field from append query based on linked table name
Here's the setup: Two linked tables called 'PHD' and 'XANS' bring in daily data from two CSV files. A union table-query puts the common data in both into the same name fields. This table-query is called 'SOLS_DATA_MERGE'. I then created a new table called 'SOLS_MAIN' and I ran an append query called 'SOLS_DATA_APPEND' to append the data in the table-query, 'SOLS_DATA_MERGE' into the new table, 'SOLS_MAIN'. The main reason for this was so that I could assign my data a primary key. Even though I have achieved my goal of merging the da...

can't apply Office 2008 1224 update
List members: I regrettably was talked into reinstalling Office 2008 for the Mac on my Intel Mac running OS 10.6.2. Everything is fine except that I can't get Office 2008-1224 Update to apply. My HD appears with a yellow triangle over it, saying the update is inapplicable. I've tried trashing the product ID as Microsoft's web page suggests; no luck. No trial copies of Office anywhere on my HD. Would appreciate any advice; thanks in advance. - Mark Pavlick This is identical to the problem I reported on 25 March (Installing Office 2008). In my case the prob...

Boxplot and Whisker Chart
Hello, I use the chart wizard\custom chart\Line on 2 axes to draw boxplot and whisker chart with percentage on the left y axes and quality on the right y axes but it doesn't show right like the others chart. Anyone know how to draw the Line on 2 axes or Line-column on 2 axes for Boxplot and Whisker Chart? Thanks, ...

Display No. of Rows in Status Bar
Hello: I'm using Excel 2003. Up until recently, whenever I apply an autofilter, my status bar would display the number of rows returned, e.g.: "25 of 100 records found". For some reason it has stopped doing that, and now just says "Filter Mode". I right clicked on the status bar, and chose "Count". It didn't help. Right now I have it on "None", which is what it was on when the row count was displaying before. I don't believe I turned anything off, but I'd sure like to have that feature back. OBTW: I had this problem a mont...