Can Form UseMicrosoft Excel Chart Instead Of Microsoft Chart Wizard

Mar 22, 2006

Hi all,

I'm trying to create a chart in a form, this is not a problem, however, the chart types available are a bit limited compared to if i inserted a Microsoft Excel Chart object.

I'd do that except I'm trying to create a chart based on a query.

Is there a way to make the chart wizard use the Microsoft Excel Chart object as its chart creator so I have access to the chart types available in that object?

any assistance much appreciated.

thanks all.

regards

keji

View Replies


ADVERTISEMENT

Using The Chart Wizard To Create A Graph

Jun 20, 2005

When I use the Chart Wizard to create a chart it looks fine in the preview but when i change it to form design - to alter the fonts etc- it gives me a graph which looks as if it comes from the Northwest database. What on earth is going on???

PS Am i best using graphs in reports or Pivot charts

View 1 Replies View Related

Limit Chart To Date Range / Chart Isn't Updating

Jun 28, 2015

I have a form with a chart , 2 textboxes for start date and end date and a button to filter the data( filter the data by date range) How do i continue from that? The chart isnt updating.

View 5 Replies View Related

Reports :: Microsoft Chart Object In Report - Formatting Line Weights

May 5, 2015

Using a Microsoft Chart Object 6.0 in an Access 2010 report. It's easy enough to do the basics and that chart responds to data.In my case, I have 12 lines, or columns, being controlled by data. It responds to the data. just fine. What I want to do is control the line weight and colour of each line through VBA.

You can click on the chart itself on the report form, but formatting the line you actually want is almost impossible. Pretending we can, you get the pop-up configuration windows and the TAB "PATTERNS". Under that, you can select "LINE" and then choose the style, color and weight. This is what I need to do in VBA.

Lines like this do not work:Graph_Data.Columns("A").Line.Weight = 5
or...
objDataSheet.Columns("A").Line.Weight = 5I tried a variety of versions of that and am pulling my hair out.

View 8 Replies View Related

Can I Create This Excel Chart In Access?

Aug 9, 2007

Dear Access Expert

I am trying to create the Excel chart see attachments (ExcelChart.jpg) in MS Access but I don't think it's possible with the Access Wizard because it doesn't allow me to use more than one data field (step 2 in the Chart Wizard)

I created the Excel Chart using a pivot table in Excel with two data fields and they are graphed simultaneously

For the Access Chart I only managed to get the "Total Delay Series" and not the "Arrival Delay Series."

Must I use Excel to make this complex chart and link it to my Access form and if so can the chart still be dynamic? My intention is to set parameters using combo boxes and then create the chart on the fly. For example currently the user sees the series for the years 2004- 2008. I want to enable the user to be to have a choice about what years (range) they want to view.

THank you so much.

View 1 Replies View Related

Modules & VBA :: Creating Excel Pivot Chart In Access

Jan 21, 2014

I've written this code in Access to create a pivot chart in Excel. All the code listed is good except for the last line. The last line creates another instance of Excel. I can't figure out what the correct syntax is.

Set xlApp = New Excel.Application
xlApp.Visible = True
Set wb1 = xlApp.Workbooks.Open("c:chi estpivot.xlsx"
wb1.Sheets.Add
wb1.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _

[code]....

View 14 Replies View Related

General :: Cannot Publish Excel Pivot Chart - Run Time Error

Oct 11, 2013

I am trying to publish an Excel Pivot Chart, but keep getting Run Time Error 1004 - Application-defined or object-defined error...

I have tried the code 2 ways:

Code:
Sub PublishChart() Worksheets("Historical_Pivot").Activate
With ActiveWorkbook.PublishObjects.Add(xlSourceChart, _
Path & "" & "AWA" & "_" & "JAMALCO" & "_" & "Chart" & ".htm", _
"Historical_Pivot", "JAMALCO", xlHtmlStatic, "ABC REQ BACKLOG_2013", "")
.Publish (True)
.AutoRepublish = False
End With
End Sub

Code:
Sub PublishChart()
Dim wb As Workbook
Dim ws As Worksheet
Set wb = ThisWorkbookSet ws = wb.Sheets("Historical_Pivot")
ws.ChartObjects("JAMALCO").Activate
With wb.PublishObjects.Add(xlSourceChart, Path & "" & "AWA" & "_" & "JAMALCO" & "_" & "Chart" & ".htm", ws _
, "", xlHtmlStatic, "", "")
.Publish (True)
End With
End Sub

View 1 Replies View Related

How To Use Data From Uploaded Excel File And Display Chart Based On Query

Aug 12, 2015

I have a graph chart and my row source type is a Query. So I retrieved data from the Query that I built.

However , I want to get the data from the uploaded excel file.

I have a form that will prompt user in the beginning to upload the excel file and replaced the old table in Access- "CrossSystemData"

Basically , I want to pull data from Excel file , Run the query(Data from excel file) then excute to "display a chart based on my query" ... Is it possible ?

Query SQL: "PolyWrongRegInsCount"

Code:
SELECT GROUPING.INSTITUTION, Count(*) AS NO_OF_GROUP
FROM (SELECT DISTINCT CATEGORY, GROUP_NO, INSTITUTION, IIF(Left(INSTITUTION,1)="P","POLYCLINIC","HOSPITAL") AS INS_TYPE FROM CrossSystemData WHERE INSTITUTION NOT LIKE "*UNKNOWN*") AS GROUPING
WHERE (((GROUPING.CATEGORY)="WRONG REG") AND ((GROUPING.INS_TYPE)="POLYCLINIC"))
GROUP BY GROUPING.INSTITUTION;

My Chart SQL :

Code:
SELECT PolyWrongRegInsCount.[INSTITUTION], PolyWrongRegInsCount.[NO_OF_GROUP]
FROM PolyWrongRegInsCount;

View 3 Replies View Related

Chart On Form

Aug 26, 2004

I AM IN A HURRY!!! FRIDAY IS MY LAST DAY!!!!!

I am trying to get a chart to work on a form,

I want the 'Results' to be the data shown (lines),
over the date range (bottom),
with value range (left)

I can't get it to do this though...

can someone please help....

THANK YOU!

View 1 Replies View Related

Thermometer Chart On Form

Jun 30, 2005

I am using a one column chart on a form (unbound object) which references a query that sums a field in my table that tracks monetary amounts. As I enter records and go to the next record the chart does not update. It only updates when I close and then open the form. Has anyone had experience using this type of chart on a form and had it update after each record was entered?

Thanks

View 2 Replies View Related

Create A Chart On A Form

Dec 6, 2006

i have about 1500 records in my database and i want to display a bar chart for each record, i can tryed creating one but when i try adding the months it says i only can add 6 fields but i want to include each month not just 6 months in the chart, this is an on going database so in the future there will be more months added. here is the picture of the form i want to be able to show 2005 and 2006 figues in the same chart

View 8 Replies View Related

Forms :: Pie Chart In A Form

Aug 6, 2013

I have a small application for booking cars into a Garage.

Tbl_Bookings:
Date in: 6.8.2013
Brief: Full Service
Approx. time: 4 hrs

Next car : 6.8.2013
Brief : Brake pads
Approx. time: 2 hrs.

Workshop capacity on any day -16 hrs.

Now my customer would like to look at a pie Chart, per date, showing 16 hrs green and 6 hrs red, so that if he can see at a glance if he still has capacity for more cars on any certain day. I can insert a Chart, but not sure how to make it do what I want.

View 6 Replies View Related

Relate Chart To Search Form On The Fly

Mar 17, 2006

Hi,

I'm having problems relating a pivotchart with search criteria automatically after the search - all on the same form. This will be a nifty trick if it is possible, and I can imagine other uses for a form like this.

Without being overly wordy, I attach a mdb in hopes that someone with a bit more skill than I will take an interest and set me on the right track.

View 1 Replies View Related

Forms :: Chart A Row In A Form Instead Of Columns

Dec 11, 2014

I'm a bit stuck on creating a chart in Access 2010. Not sure if I've set my table up right or not

Here's my table design

And the input form

My data is laid out like so

When I insert a chart though, I'm lost. It's like it's totally ignoring my data. The data isn't mine, it says east, north and west like a 'default preview chart'. The row source is

Code:
SELECT [student_id],Count(*) AS [Count] FROM [tblProgressLevels] GROUP BY [student_id];

Which means nothing to me I've managed to get most of the other stuff figured out, but these charts are confusing me.

Output??

What I want it to do is show how the student is progressing but I've got it all back to front I think. How could I lay my data out so I have a single English column, a single maths and a single science and they still go up in terms like my form shows; they're all in the same table at the moment laid out the same way as I set up the English tracking.

I also just realised I'm trying to chart alphanumeric values stupid boy... Can Access do a conversion where I make a lookup table so that 1c = 1, 1b = 2, 1a = 3, 2c = 4, 2b = 5 etc. or would a query work?

View 2 Replies View Related

Display Html/chart/image On Form

Nov 7, 2006

lets say i have a data field which contains hyperlink for a html file, can i display the content of the file from the hyperlink in the form when the form is loaded?

View 1 Replies View Related

Forms :: Chart In Form Skipping First Row Of Data

Sep 11, 2014

I have a chart in a form which gets its data from a cross-tab query. The chart was working fine and still is besides the fact the it is skipping the first row of data, or reading/treating it as a header. I had this problem before and the only way i could get around it was to re-create the charts. As there are many charts i want to avoid doing this again and find out why this is happening to prevent it happening again.

View 6 Replies View Related

Reports :: Control Form Pivot Chart In A Report?

Dec 2, 2014

I have a bar pivot chart made in a form this load fine, I have the below VBA code in place to control the bar color depending on what the bar show.

Set frms = Forms![OtherCases created by Indv by Month chart].Form.ChartSpace.Charts(0)
Dim i As Long
With frms
For i = 0 To Forms![OtherCases created by Indv by Month chart].Form.ChartSpace.Charts(0).SeriesCollection.Count - 1
With .SeriesCollection(i).Name
Select Case Forms![OtherCases created by Indv by Month

[code].....

When I then open the Report this is not working at all each bar just get a random color regardless what the bar show.how to convert the above to fit a Pivot chart form a form that is displayed on a report.

View 1 Replies View Related

Forms :: Opening A Form Pivot Chart From A Button?

Mar 22, 2013

I made a form pivot chart. When I open it by going to forms and opening, it opens in the pivot chart view. However, I created a button on a switchboard form for easy access to this pivot chart form and when it opens from the button it is in form view and not pivot chart view. How can I get it to open in pivot chart view from this button so that the users don't have to keep switching it to pivot chart view manually?

View 1 Replies View Related

Forms :: Error 1907 When Placing Chart Control Within A Form

Nov 3, 2014

I have just tried experimenting with placing a Chart control within a form (Access 2010). Although the chart ultimately seems to work (based on my one simple example), I'm getting an Error 1907 (Could not register font.......) each time I launch the database or reload or edit the form.

This error message is itself contained within a "Configuration Progress" screen for MS Office Prof + 2010 which seems to complete if I select Ignore the error message but runs again each time the database is launched (with the same error message showing up part way through). I am logged on as Administrator.

View 2 Replies View Related

Help With A Chart

Oct 11, 2005

I have a stack bar chart that shows hours an event took including delays so its 3 stacked bars. I want to add a goal or target line to the chart but can't seem to keep the bars stack because I have to change the chart type. Any ideas ??

Jon

View 1 Replies View Related

Need Chart Help

Jun 12, 2007

I have a report that is populating from one query. It takes data for a year and groups it by month with the lost time for that month. I am comparing 3 years data 20005, 2006, and 2007. I have set the chart up and it looks good except that my time for each month goes into the data area as a "CountOf" lost time and all months are therefore one. I want to show the lost time for each month. I have tried right clicking on the field in the data area and Autocalc is set to Count, but everything else is grayed out and unavailable. How can I change this setting to just display the value? Thanks in advance for the help.

View 1 Replies View Related

Chart

Dec 5, 2005

I need some help with charts:

I know that the wizard wont allow me to put in more than six fields in the chart. Is there any way that I can get around this???

PivotChart: if i have a field named "Jan", when i put it in the pivot chart or table as a sum, it changes the name to Sum_Of_Jan. Is there any way that i can change this??
thank you.

View 1 Replies View Related

Where Did I See That Chart?

Mar 27, 2006

I once saw in this forum a link to a table that had instructions for referencing forms, controls, subforms and all that good stuff depending on which form you are on. I have searched and searched and I can't retrace my steps to find it again. Could someone please point me to it?

Thanks.

-Dave

View 1 Replies View Related

Chart Help

Oct 18, 2006

What field do I select from my table and where do I place them on the sample
graph in order to get a pie chart showing the correct information?


Details:
I'm trying to insert a chart into a report. Each page of the report is for
a different model name and then breaks down the model into parts:

REPORT:
Model 1
section a=25% section b=30% section c=45% ....

I would like a pie chart to represent the way each model is broken down (one
slice=section a, one slice=section b....)

Here is the table I'm trying to base the charts off of:
section a section b section c
Model 1 25 30 45
Model 2 ..................

View 1 Replies View Related

Chart Query

Aug 19, 2006

I'm currently using MS Access 2000 - When using the chart wizard is there any way of sorting the data by month ? At present I'm getting all my data on one chart but I want to spilt this into seperate months. (ie; 1 chart for July, 1 chart for Aug etc) I know there is the option for choosing 'between dates' but I don't want to have to do a fresh chart every time

Regards

Richard

View 1 Replies View Related

Max 6 Fields Per Chart?

Nov 22, 2006

Hi,

I am trying to add a chart to a form/report which will show sickness for each month (ie. 12 fields).

When I goto insert - chart and start adding my fields Access tells me I'm only allowed six!

What am I doing wrong?

Cheers
Lee

View 3 Replies View Related







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