Inserting Chart Into Userform
May 17, 2014
I'm trying to use the below code to insert a chart into a userfom, i'm using a tutorial that I've seen used on a few sites.
So far I found this code on the internet, the chart is the worksheet PMC
Set CurrentChart = Sheets("PMC").ChartObject("PMC").Chart
Fname = ThisWorkbook.Path & " emp.gif"
CurrentChart.Export Filename:=Fname, FilterName:="GIF"
Dashboard.Image1.Picture = LoadPicture(Fname)
Trying to load the chart into the image control image1 on the dashboard userform.
The debugger keeps hitting the chartobject section and grinding to a halt.
I have seen other ways of doign this but they require access to different libraries and work is restrictive with these things!
Also I have tried:
Set CurrentChart = Sheets("PMC").ChartObject(1).Chart
Fname = ThisWorkbook.Path & " emp.gif"
CurrentChart.Export Filename:=Fname, FilterName:="GIF"
Dashboard.Image1.Picture = LoadPicture(Fname)
Also the error message i get is: Unable to get the chart objects property of the chart class
View 2 Replies
ADVERTISEMENT
Aug 31, 2007
I have a feeling this is a stupid question, but I can't figure it out right now...
I have a worksheet with a bunch of charts as worksheets. I want to put command buttons on these charts. Whenever I select a tab which as a chart on it, my controls are grayed out, and I cannot insert a button. When I select a tab of a regular worksheet, I can insert buttons to my heart's content. Why can I not insert controls to the tabs which are charts? The ridiculous thing is, I have done it before. When I open that file, my buttons are on the chart. However, even in that sheet, I cannot insert more. Do I have a setting that I have changed, or somewhere I can look to enable the ability to put controls on a chart?
View 4 Replies
View Related
Nov 6, 2009
I've been inserting some rows in some sheets and everything is sound... Until I meet a chart! Charts in general are terrain I yet have to explore (and will be coming Monday)...
I insert a row like this: ...
View 14 Replies
View Related
Oct 4, 2008
I'm working on a sreadsheet for inserting and collating information for a fleet of vehicles. I have userforms for inserting various pieces of information when the vehicle is new or leaving the fleet.
I would like to use a userform for inserting weekly information. I know how to insert the basic information in columns but I'm stumped for working in rows and with inserting information at different times.
View 4 Replies
View Related
May 14, 2007
I'm running in to some problems on creating a Userform. I will try to explain it as best as possible. Right now I have a userform set up with 2 ComboBoxes. Here is my current code. It's not near complete.
Private Sub CommandButton1_Click()
Set ufStart = Worksheets("Data"). Range("AP4")
Set valNames = Worksheets("MasterData").Range("AA6")
Set valMonths = Worksheets("MasterData").Range("H3")
Set SelMonth = ComboBox2.ListIndex
Set SelName = ComboBox1.ListIndex
If TextBox1.Value > 0 Then
ufStart.Offset(SelName, SelMonth).Value = TextBox1
Else: End If
End Sub
The way it's supposed to go, is if TextBox1.Value is greater then 0... then go to UfStart and Offset by Row, which is ComboBox1 Selection Index Value and by Column, which is ComboBox2 Selection Index Value. I can't get the sub to get past Set SelMonth = ComboBox2.ListIndex.
View 6 Replies
View Related
Nov 23, 2007
I m trying to sort this out myself before posting but its driving me crazy! I have the following userform :-
I would like all that data entered into a worksheet called "Purchase Record" into the following cells:-
View 4 Replies
View Related
Aug 7, 2009
I have a userform that contains a textbox. How can I insert a "hard return" in the text portion to include a blank line between paragraphs?
View 2 Replies
View Related
Dec 27, 2009
I have a userform with 4 text boxes. One of the boxes you have to enter in an amount. i.e. £25.52 This value gets put into cell E17 in my spreadsheet. When I click the button and it puts it in, it puts it in the cell as "£25.52" with left alignment and does not apply it as the accounting style, as set to that cell. The same happens if I just type "25.52" instead.
I also have a formula applied so that if E18 is "Yes", E19 will display "£0.00" otherwise, E19 should display the value of E17. And then column E has a total at the bottom of the values in Column E. Even when "£25.52" or "25.52" is entered in, it comes up in cell E19 as 25.52 (not with accounting style) but it doesn't add up in the sum at the bottom of the column.
View 2 Replies
View Related
Dec 11, 2011
I am having difficulty writing code to insert a hyperlink from a command button on a userform.
I have set up a worksheet to be a data base for a lot of new files which are being created on a daily basis. The userform when activated asks the user to input certain information about the new file being stored in the data base (ie file name, date created, relevant project, description, who created it, etc). I have put a command button on the userform which I would like to activate the "Insert Hyperlink" menu so the user can then navigate to the location of the file being stored and have that hyperlink stored in a cell against the file when the "Submit" button is clicked on the userform.
I have read almost every thread on inserting hyperlinks with vba but none seem related to my needs. Using Windows 7 and Excel 2007
View 3 Replies
View Related
Oct 18, 2007
I was wondering if someone could give me some sample code on how I can get a chart to appear on a userform. What I have is a userform that allows the users to change the inputs that are used in preparing the chart. Then I want a second userform to display the new chart.
I searched the posts and saw reference to saving it as a picture but I am not sure how to go about this. Can I save it as a picture within the excel file? Or does it have to be external. If so, how is this done. And can I do it without interupting what the user is doing on the forms.
View 7 Replies
View Related
Nov 20, 2006
I'm trying to display a graph I've created in a worksheet, in a userform. But it won't work ..
Private Sub UserForm_Initialize()
Sheets("graphraw1").Select
image1 = ActiveChart.ChartArea.Select
End Sub
View 9 Replies
View Related
Jul 26, 2006
I'm trying to make a chart (which will also be on the UserForm) from data that a user will enter onto a UserForm. The problem is that I am trying to select a data range as one of the charts 'series' but I can't quite find the right code. At the moment it looks like this:
ActiveChart.SeriesCollection(1).Values = Range(BMIM20Ttl, BMIM2025Ttl, BMIM2530Ttl, BMIM3040Ttl, BMIM40Ttl)
ActiveChart.SeriesCollection(1).Name = " Total"
ActiveChart.SeriesCollection(2).Values = Range(BMIM2075, BMIM202575, ...
The problem is with the Range function.
View 9 Replies
View Related
May 28, 2014
I am using Access as a backend and Excel as a frontend for my project. Now I have to display a chart in the userform using data from Access database .
View 2 Replies
View Related
Jul 14, 2006
I have made a simple procedure (which will extend to make something that I have to make but for time being) it asks user to select a chart type in a userform using option buttons and then the chosen chart type is taken as the chart type and makes the chart.
problem is that the typechart - variable to identify the chosen chart type - is not being recognised. Here's the coding, the variable is not passed (in yellow bolded) from one procedure to another?
Private Sub NextButton_Click()
Call ShowType
If bFlag = False Then
MsgBox "Not Selected"
Call ShowType
Else
Call MakeChart
End If
End Sub
View 5 Replies
View Related
Apr 15, 2014
I want to add a user-form on a chart, which will have check-boxes that will allow me to select series(lines) that I want see and compare in a chart. Currently my line chart has 24 series (Lines) which makes the chart very difficult to view and looks very busy. How do I add list of check-boxes that will allow me to select one or multiple lines that I want to see at a time?
View 2 Replies
View Related
Jul 12, 2013
How do I paste the first chart into the second chart but maintain the format of the second chart?
View 2 Replies
View Related
Jan 14, 2014
I need to plot various data on top of stock charts.
This data could be irregular in date: it could be weekly, or simply random.
To plot this data by itself requires a Scatter Chart.
From what I know so far, you CANNOT DO THIS.
However, I suspect this could be done if I build a Stock Chart from scratch using a Scatter Chart.
Error bars can be used to make the tails, however, I don't know how they built the body bar which has the characteristics of a bar (border, and interior.)
But since I don't really need those two characteristics, I just need a wider error bar line that is provided in the chart edit window. I'm guess through a macro, there are wider line widths assignable.
View 5 Replies
View Related
Feb 24, 2007
I know this has been discussed a number of times, but here is my problem
I have three charts in my workbook. I want to attach a macro so that when the chart is clicked it returns to Sheet - Home. I have using the following:
worksheets("Home").activate. But after I protect each chart and the workbook, and save and exit. When I reload the Workbook it has forgotten the assigned macros and nothing happens.
View 7 Replies
View Related
Nov 27, 2011
I am looking for a creative way to display a pie chart within a data point marker of a line chart.
My database has 3 value columns, Type1, Type2 and the Total (Type1 + Type2)
these are recorded per day (Date, in Column A)
I have a line chart that displays the total by date, but I want to find a way to display the percentage split of a particular day by type.
I was thinking to load the chart image into the Data point marker, but i don't think that is the best way as the data is updated daily and I would have to do it each day for a few line charts.
The other way I was thinking about was to have a generic Pie chat in the Line chart (Maybe in a corner) and the pie would update depending on way date series was selected or Mouseover'd)
the way that I am approaching it at the movement (Not the best way and by far not the coolest way. Is to have a list of all the dates in a column next to the Line chart and using some VBA, what ever date is selected in the column the pie chart displays the corresponding data. But eh challenge is that when there is alot of dates, I am going to be scrolling up and down.
I am using Excel 2010, but I cant not use the slicer's as the other users do not have 2010, they have 2007.
View 1 Replies
View Related
Dec 29, 2011
I have a spreadsheet created in Excel 2003 (which is what we use at work, unfortunately).
My employees periodically take a test to ensure they have certain items memorized (or are making progress to that end). The spreadsheet rows show all 46 of my employees, and their test scores. The columns are the dates that the tests are administered. I can create a line graph based on the chart data, and interpolate these data with no problems.
The problem is that there are 46 employees! 46 lines on the same graph make for a very cluttered, hard to understand visual. I want to simplify the view by "filtering out" some of the data.
I have an additional column in my spreadsheet for each employee's work area (Area 1, Area 2, etc), and another column with data based on first letter of last name (the values here could be "A-G", "H-M", "N-S" and "T-Z", for example). I figure i could filter my line graph based on these two columns. For example, somehow select just Area 1, and reduce the number of lines on the graph to 16. Or better yet, Choose "Area 2" AND "A-M" and end up with 7 employees (and therefore 7 lines on the graph).
Here's what i have tried:
1) Select the work area column, and use the Filter, which created a drop-down list at the column heading. When i use this drop-down list, i can easily filter the data in the worksheet by Work Area, but this is not reflected in the line graph, which still shows all 46 lines. The problem was that i forgot that i had set the Calculation Options to "Manual". Setting this to "Automatic" (or leaving it on Manual and pressing F9) solved the problem, as the chart now updates when i use the filters. Calculation options are under the "Formula" tab in 2007, or in Tools -> Options -> [either calculation or formula, i forget what it's called] in 2003.
2) Create several separate line graphs in several separate sheets. I wouldn't want to assign someone else the task of maintaining a spreadsheet of such inefficient design.
View 1 Replies
View Related
Jul 14, 2012
I have created a population pyramid and want to add another chart on the secondary axis which I can do. The part which I seem not to be able to complete is getting the line chart secondary axis to read from the primary y axis. It seems to add a new axis, even when I delete this the line chart does not read correctly.
View 1 Replies
View Related
Apr 18, 2013
How can I add missing values to the axis in a pivot chart line chart? I have a numerical X-axis with values such as 0,1,5,8,14, etc. I have another set of Y values that correspond to the X values. If this was an XY-scatter plot I'd be able to plot X vs. Y and connect the dots for "gaps" in the X values. Since it's a pivot chart I cannot use an XY-scatter plot, I can only use a line chart. The line chart doesn't give me the ability to add the "missing" values, so it gives the impression that my data is more closely packed than it is. The data source is external to my spreadsheet, so I cannot add the values before creating the pivot table/chart.
View 1 Replies
View Related
Mar 26, 2009
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 4 Replies
View Related
Jun 30, 2009
I would like combine (overlay) a bubble chart with a connected point scatter chart. I understand that, without VBA, this is not possible. However, I understand that, by using VBA, the markers of a scatter chart can be configured as circles with their size proportional to values in a specified column. This pseudo-bubble chart can then easily be combined with a connected point scatter chart.
My question is: does anyone have any VBA code to share that shows how to configure a scatter chart as the type of pseudo-bubble chart described above.
View 2 Replies
View Related
Feb 15, 2012
I am trying to overlay a line chart on top of a stacked column chart. The stacked column chart is a chart where the x axis is dates and the y axis is amount. The line chart is a projected amount that I will reach in few years; the x axis is the date while the y axis is an amount. I can get a chart that has a line and stacked columns, but ever time, the dates get messed up. The line has an extremely wide date range while the columns only have about a month of data.
View 9 Replies
View Related
Jan 22, 2008
Is there a way to display only the current month and the past 11 months in a Line Chart in Excel? So if I was to print Jan 2008 Excel graph, it would only display Feb 2007 - Jan 2008 data charting.
The spreadsheet of the data contains data for Jan 2005 - Jan 2008 so far, but only the current month with the past 11 months should display in the line chart depending on what is the current month.
View 13 Replies
View Related
Jul 19, 2012
My question is regarding changing properties in a chart without activating it. My current example is with adding data labels, but there are many other instances I could use this information in. Here is my current code:
VB: ActiveChart.SeriesCollection(2).ApplyDataLabels
However, I was hoping to replace it with something like this:
VB: Sheets("Dashboard").ChartObjects("Chart 1").SeriesCollection(2).ApplyDataLabels
I get the "Object doesn't support this property/method" error. Is there a way to do this? It just seems inefficient to have to activate the chart in order to make changes.
View 2 Replies
View Related
Sep 15, 2014
In the attached file I have the data which shows me the market size in value, my market share in value & I did a calculation to get the percentage. What I need is a chart that shows me the market size in column graph, my market share in line graph and I want the percentages to be showing also.
View 3 Replies
View Related
Dec 17, 2013
I have created a pie chart showing top 10 best selling categories. However, on this pie chart, I want %age of overall sales to be shown.
At the moment say I put in the following
Catalogue 1 100
Catalogue 2 98
Catalogue 3 92
Catalogue 4 85
Catalogue 5 84
Catalogue 6 75
[Code]....
I add Data Labels and select the percentages. This shows at Cat 1 having 12.5% of the sales (100 of 800 sales), Cat 2 having 12.25%, and so on..... However, what you don't see is the following data:
Catalogue 11 60
Catalogue 12 58
Catalogue 13 57
Catalogue 14 57
Catalogue 15 56
So based on 1,088 sales, Cat 1 at 100 is actually only 9.19% of TOTAL sales.
I understand what is happening, the chart is giving the percentage based on the data inputted into the chart.
I did consider adding an 11th category to the chart, which was the total of Catalogues 11-15. Whilst this does give a more accurate percentage figure (as now all sales have been inputted), it makes the chart look ****
Is there a way of either adding the 11th category, and then "hiding" it, so that the chart doesn't display it, but uses it's value to calculate Catalogues 1-10s percentage?
BTW: The reason I ask is that I could be dealing with anywhere from 30 to over 100 catalogues. So it's not ideal showing the others in 1 chart.
View 1 Replies
View Related
Nov 28, 2008
I have a pareto chart(Bar & Cumulative Line Chart) that I would like to have the line orginate at x = 0 & y = 0 without changing the position of the other points on the line chart.
Basically this is for better visual appearance. When I add a 0 to the table, it skews the alignment of the line chart with the corresponding bar chart.
View 7 Replies
View Related
