I'm not too familiar with VB, and I'm trying to narrow down why my macro (and how) is creating a second, duplicate chart. I only need the chart to be created (and the corresponding data fields on the 3rd worksheet) once.
View 2 Replies
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 2 Replies View RelatedI have creating a chart. All the information in the source data appears to me to be ok but the chart isn't been displayed.
View 9 Replies View RelatedI am trying to create a Pivot Chart. My data consist of staff whom had errors in their work done. The data has a time when the work was completed by the staff. I would like to generate a Pivot Chart that has a line chart that shows when the work was completed based on the time and can be sorted easily by team, date, staff ,shift and errors.I know the easiest way is by Pivot Chart. I am not sure how to accomplish this as I had tried with the Pivot Chart and it did not work.
View 4 Replies View RelatedI'm trying to show learner progress during our half term collections but the values we track are similar to that below
2B+
2B
2B-
2C+
2C
2C-
1A+
1A
When I attempt to make a chart in the normal format it doesn't recognise the value.
i am looking at creating a combine chart for 3 variables.how to achieve that?
TeamSubTeamsScore
A X 20
Y 25
B X 10
Y 20
C X 15
Y 10
I am creating a graph for data that I collected. It was pretty easy to create. The problem is that I want to be able to have certain segments a red color. This is the data that I have
3380
0831
01374
01570
01928
02403
03003
03703
04128
04333
04777
05283
15732
16184
16822
06974
07310
07700
07995
08040
08402
08531
09208
39473
110006
010450
011072
111424
111691
112177
012925
I would like to create a line segment which is easy to do. But I need certain segments to be red. Such as this the line segment between 10006-10450 should be red. And the segment from 11424-11691 should be red too. I have attached my current chart that does not have the red.
For work, I'm doing a project for Quality Control. I'm looking to create a Bar Chart (horizontal bars) with 2 "vertical" lines to indicate the range of acceptable values
Attached to this Post is a *.pdf that (hopefully) further explains what I'm looking for.
I have a bunch of data about companies in an Excel workbook. I need to be able to create a "summary document" about a selected company in word. One of the items that needs to be in this summary is a pie chart.
This code works fine for generating the basic text of the document:
Code:
Sub export_to_word()
Dim wrdApp As Word.Application
Dim wrdDoc As Word.Document
Dim companyName As String
Dim address As String
Dim revenue As String
[code]....
Creating the chart has been more problematic. I adapted the following code from an example found on MSDN:
Code:
Dim valueChart As Chart
Dim chartWorkSheet As Excel.Worksheet
Set valueChart = wrdDoc.Shapes.AddChart.Chart
valueChart.ChartType = xl3DPie
Set chartWorkSheet = valueChart.ChartData.Workbook.Worksheets(1)
chartWorkSheet.ListObjects("Table1").Resize chartWorkSheet.Range("A1:B12")
[code]....
What I've found though is that this code is based on a macro inside the word document, not excel. So it runs fine from within word, but within excel it throws an error at this line
Code:
Set chartWorkSheet = valueChart.ChartData.Workbook.Worksheets(1)
because ChartData is not in the object model in Excel. how to proceed at this point.
My chart is coming in blank when I set up a line chart. This is my data that I selected and then pressed chart. 1997
63.9%
1998
63.2%
[Code].....
I have a column with values​​:
15 1 16 11 2 15 31 30 26 49
Need to build a diagram, like parabola.
Once again, the task:
For example, we have a number 2, 5 and 10. It will hit 1-2 3 times, 2 times 3-5, 6-10 1 times.
And that we get a parabola.
Example:
How to do it?
I am working on an excel macro for work to work with data processing. Basically, it takes a bunch of CSV files and creates a workbook with each file as a new Worksheet; then it has the user enter some calibration data; and finally fills a column with the calculations to convert the data into the correct units. I would like to get it to put an XY Scatter chart of the data on each pages, but I'm having some problems with it. I recorded a macro to get an idea of what the code should look like, but when I put it into the macro I'm writing it places all of the charts on the last worksheet.
Here is the code that I came up with for the chart generation:
Code:
ActiveSheet.Shapes.AddChart.Select
ActiveChart.ChartType = xlXYScatterLinesNoMarkers
ActiveChart.SetSourceData Source:=Worksheets(i).Range("D:D,F:F")
Columns D and F are the two that contain the data that I want to plot. In my macro this is running inside a look so Worksheets(i) is selecting the correct ranges on the correct worksheet. I think my problem is that after the merged workbook is created it is defaulting to the last worksheet being the ActiveSheet, and I don't know how to change that.
I am not sure if this is possible. I wish to have a chart in a worksheet linked to a stock chart on a webpage.
For example, consider this chart on Yahoo Finance. At present every week, I have to go to the webpage and copy the chart and then paste it into a worksheet.
Is there a way I can automate this task by linking the chart to an Excel object or by any other way?
i have this data.
WeekFRM CURRCY Account val val2 val3 val4
42100¢BBHBANK403522
43100¢BK200 001310
44100ABBHBANK3013
45100ABK200 9043
46100CBBHBANK10106
47100EBBHBANK903420
48100EBK200 503527
How do i get this into a chart, with week along the bottom, Amount on the left. This is starting to be a pain now as i need to seperate by currency, but a pivot chart looks really realy messy with all the drop down boxes and stuff. I dont mind using drop don boxes, in fact, its going to be essential. but the pivot one look horrible.
I am using the VBA Chart Control and I have the following instruction;
Me.ChartSpace1.Axes(ChartAxisPositionEnum.chAxisPositionCategory).Numb erFormat = "mm/dd/yy"
The chart is a "chChartTypeLine". the problem is that i cannot change the format of the X-Axis to a Date (mm/dd/yy) format no matter what I try? I keeps wanting to keep it as "General", here is the code;
Private Sub CommandButton1_Click()
Dim ser As ChSeries
Dim cht As ChChart
Dim MinValue As Double
Dim MaxValue As Double
MinValue = Sheet1.Range("D2").Value + 10
MaxValue = Sheet1.Range("A2").Value
I have a line Chart and want to create a static horizontal/indicator line.
I cannot create a new series to plot this horizontal line as I'm using an external data source (OLAP cube) as source data for the chart.
I am creating a chart with more than 2000 dates (each day). How can I format the axis so it only displays the 1st day of each quarter (01/01/2010, 01/04/2010, 01/07/2010...).
At the moment I cannot format the axis and minor/major units remain numbers.
I am using Excel 2010 and European date format.
I am trying to create a dynamic Excel line chart.
All is well, except for my x-axis (which is a text axis). It currently looks like this: Dynamic axis.jpg
I am using the Offset formula. The formula for my x-axis is =OFFSET(Worksheet1!$D$4,0,-3,COUNT(Worksheet1!$D$4:$D$36)). This is to show the axis if cells in Column D are filled up appropriately.
However, in the cells containing the axis name itself, this formula is used =IF(D9=0,NA(),'Worksheet2'!A6). I've tried removing the formula from these cell, but that didn't solve the problem.
I am trying to automatically generate an organisation chart in excel from a dynamic list of employees. in column 'A' will be the "manager's name", column 'B" will be the "employee name", column 'C' will be the "employee number" & column 'D' will be the "employee days" number (an potentially a few more employee attributes)
I would like a printable org chart that is created on another tab which is generated from this list, ideally with the "employee name" and their other attributes shown in the chart.
how this can be done in excel, maybe VBA?
Is it possible to put in Trend Lines when creating a stacked column chart?
I've tried in Excel 2003 and 2010 but it doesn't appear that it is possible.
I am doing an ANOVA analysis of survey results for a set of products, and would like to present a chart to graphically represent the results.
View 1 Replies View RelatedI have a table that can at any point have from a couple hundred up to a couple thousand rows. Within this table lies a column entitled " Offer ". I want to plot the figures in the offer column as a frequency distribution chart.
I plan to do this by listing the x-values (Offer figures), and then using count if formulas to calculate the frequency of that x-value. Then using a simple clustsered column chart to create the visualisation of the frequency distribution.
My question is.... in my large data set, is there any way to get VBA to insert a list of the range of figures in the Offer Column, ? I can figure out how to copy down the countif formula to populate the corresponding frequency column, but how can I have some VBA to dynamically adjust my x-values (offer figures)?
For example... say in the first data set I have
Offer, Frequency
1 10
2 20
3 25
4 20
5 15
that's fine if I make the chart, but what if the data set changes, I want VBA to give me a list of all the offer values, and then I can write some code to insert and copy down along the frequency column the countif formula.
The ultimate goal is to have a frequency chart that will be synced to the self-updating dataset.
I'd like to use two columns / labels to create a colorful bar chart that just piles each field value on top of each other and shows the amount (and percent of total if I can) along the first column's values next to the bar chart something like below..
So column 1 is the "entity name" and column 2 is the "value/amount".
I can't make this chart look right at all. I have Excel 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.
I have a long complicated macro that processes a ton of data and gives the output in a new sheet. I then want to create new buttons (or some sort of user clickable triggers) on this new sheet that runs another macro.
I have got the actual adding of buttons in the sheet working, but I can't find a way to automatically assign macros to newly generated buttons during runtime. Is this even possible (or are there any clever tricks I could use to get around this?)
I am creating a macro that when cell range H7:H78 = x then the cell in the same row but column A changes to r. This is what I have so far.
View 4 Replies View RelatedI have a workbook with 20 worksheets. I would like to create a Macro on each sheet that when you click a button it creates an email to a list of recipeients for each sheet.
View 14 Replies View RelatedI have a text document to which i need to do some changes and then turn it into CSV. Here are some lines of what the document looks like and below i will show you what i need it to look like. So i open the document with Excel and next I'm not sure how to do what i will show you below. Original:
HTML 111text
112text
113text
Here is how i need it:
HTML 1,1,1,"text"
1,1,2,"text"
1,1,3,"text"
I am working with excel 2003. I get a workbook sent to me via Email that has 12 tabs on it and each tab has to be printed out. The fastest way that I know, to get this done is start with tab 1; hit alt+f, u, alt+f, enter, Ctrl+P, enter, Ctrl+page down ( to move to next tab and do it all over again), each tab is a slightly different width so I am constantly have to use "Fit to Page" but each tab will fit on one page easy.
I was wondering can I use a key stroke macro to print this workbook. I actually get 5 workbooks like this every night, it does not really take that long, maybe I am just being lazy, I was thinking that I might be able to use a key stroke macro and then name it for what ever workbook it works with (workbook 1 print ) but I don't no if this will work or if there is an easier way to get the printing job done.
I can't upload the workbook but I could create a simple say 5 tab workbook that has no data in but has same formatting and upload that if you need to see what I am doing.
I want to create a new excel application through macro. I basically want to transfer few columns from the parent workbook to new workbook. but these new workbook must be contained in a new excel application.
View 2 Replies View Related
