Creating Chart On Multiple Worksheets

Jul 7, 2014

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.

View 1 Replies


ADVERTISEMENT

Odd Chart: Combine Data From Multiple Worksheets And Make A Chart

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

Creating List Of Data From Multiple Worksheets

May 13, 2009

I am trying to create a list of residents, unit types, and unit numbers. I have 3 problems with the following code.

1) The code ignores sheets that have no value in the specified cell. I need it to return a blank cell for those in order to keep the data in each column matched with the sheet it came from.

2) The code includes data from hidden sheets. I only want to list data from unhidden sheets. And more specifically, I want to omit data from unhidden sheets that have their tab colored black.

3) The code includes data from the sheet named "Totals" which I thought I was telling it to ignore.

View 9 Replies View Related

Creating A VBA Chart

Jul 8, 2009

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 Related

Creating A Chart ..

Apr 21, 2008

I 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 Related

Copying Data From Multiple Worksheets To Multiple Worksheets In Another Workbook VBA

May 14, 2012

I have 2 nearly identical workbooks and I need to update historical data from the old workbook into the newer one.

My current Coding Snippets that I want to use look like the following:

Code:
Sub UpdateWorkbook()
Dim ws As Worksheet
Dim r1 As String
Dim r2 As String
Dim r3 As String
Dim r4 As String
Dim r5 As String
Dim r6 As String

[code]....

Now, this code isn't working I suspect because the Copy and PasteSpecial Functions don't work the way I wish to.

View 4 Replies View Related

Macro Creating Second Chart

Aug 8, 2006

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 View Related

Creating Pivot Chart

Jan 15, 2007

I 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 Related

Creating A Chart Using Non Numeric Values

May 20, 2014

I'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.

View 1 Replies View Related

Looking At Creating A Combine Chart For 3 Variables?

Mar 25, 2014

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

View 3 Replies View Related

Creating Chart With Segments Another Color?

Jul 15, 2014

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.

View 2 Replies View Related

Creating Bar Chart With Acceptable Range

Dec 29, 2009

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.

View 4 Replies View Related

Creating Word Chart From Excel Via VBA?

May 2, 2013

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.

View 1 Replies View Related

Creating Excel Line Chart?

Mar 10, 2014

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].....

View 9 Replies View Related

Creating Chart By The Number Of Values

Jun 12, 2014

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?

View 1 Replies View Related

Creating Link Between A Chart On A Webpage

Feb 16, 2010

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?

View 9 Replies View Related

Creating Chart With Mutiple Axis

Oct 20, 2006

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.

View 5 Replies View Related

Creating New Worksheets From Given List

Jun 1, 2009

I have got a worksheet wherein Column A contains the Customer Code, & Column B contains the Customer name. I want to create new worksheets based on the Customer Codes in Column A i.e for each Customer Code, new worksheet should be created wherein I would later on enter some formatting & data in the worksheets. When I select Delete worksheets, all the work sheets other than the 1st worksheet should be deleted.

View 2 Replies View Related

Creating Worksheets From Template

Feb 2, 2010

Private Sub AddWorksheets()

For Each c In Sheets("Worksheet Names").Range("A1:A24")
If c.Value "" Then
Worksheets("Sheet1").Copy
Sheets.Add after:=Worksheets(Worksheets.Count)
ActiveSheet.Name = c.Value
End If

Next c
End Sub

Strange....
I have a list of worksheet names in Sheets("Worksheet Names").Range("A1:A24").

I need to create a new worksheet for each listing and use sheet1 as the template for all...

The above code creates 22 blank WORKBOOKS, not worksheets.

View 9 Replies View Related

Creating A Date Format Using OCW Chart Control

Jan 18, 2009

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

View 9 Replies View Related

Add Horizontal Line To Chart Without Creating New Series

Aug 25, 2006

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.

View 8 Replies View Related

Creating Identical Cells In Different Worksheets

Jun 13, 2007

I am creating one big workbook with several different worksheets. I need to make the first two columns of every worksheet identical.

I would like to make it so that when an item is changed in any cell in any column on any worksheet, the other worksheets automatically change to become identical.

View 9 Replies View Related

Creating Worksheets And Copying Code

Sep 2, 2008

My macro does some calculations for a worksheet. I need the macro to loop through all the worksheets regardless of how many worksheets there are. My first sheet is a summary page with the names of the subsequent sheets that the macro needs to do calculation on. I need the macro to recognize the worksheet names in the summary page and run for each worksheet name. For instance the next time I run the macro I may have fewer sheets of more sheet names in the column. It sounds almost like an Indirect function problem.

View 9 Replies View Related

Creating New Worksheets From A List Of Names

Oct 11, 2006

debugging issues without changing the code dramatically. I think I've basically "got it" but there are a few lines that I think are problematic. I've written notes to highlight my thinking.

Let me give a basic discription of what I'm trying to do: This file lists where a company has offices. I'm want my subroutine to 1) Sort the cities in alphabetical order (this occurs at the end of the code), 2) for each of the cities listed in "AllCities" worksheet, check whether there is a additional corresponding worksheet of the same city name, and if there isn't one, the subroutine would automatically add it, and 3) delete any worksheet of a city name that is NOT found in the listings found in the "AllCities" worksheet.

View 8 Replies View Related

Excel 2010 :: Creating A Chart With More Than 2000 Dates (each Day)

Apr 26, 2014

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.

View 2 Replies View Related

Offset Formula - Creating Dynamic Line Chart

May 28, 2014

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.

View 5 Replies View Related

Creating Organisation Chart In Excel From Employee List?

Nov 3, 2011

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?

View 3 Replies View Related

Put In Trend Lines When Creating Stacked Column Chart?

Apr 3, 2012

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.

View 3 Replies View Related

Creating Chart To Represent Results On ANOVA Analysis

Oct 12, 2012

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 Related

Creating Frequency Distribution Chart From Large Dataset - VBA?

Dec 16, 2013

I 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.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved