473,804 Members | 2,112 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Controlling Chart Design

Walt in Decatur
20 New Member
Is there a way to control Access charts to the degree that can be done in Excel? Specifically, I would like to be able to define colors and use the DLookUp function to define the input for the axis labels. I'm using Access 2003.

Another thing that is weird, is that after creating a chart with the wizard, the chart displayed in the design view is the "generic chart" rather than the actual chart. Why??? It only shows a limited number of actual data series, so when I adjust the font size, it gets adjusted for only some of them (when I check out the preview). Very clunky indeed.

Any work-arounds or tricks for working with charts to have them behave will be appreciated.
Sep 21 '07 #1
1 1895
nico5038
3,080 Recognized Expert Specialist
The Access chart is indeed inferior to the excel chart. Thus when I need a good chart I use automation to create an excel graph.
For a guide check the chapter 12 download of the Access Cookbook:
http://examples.oreilly.com/accesscook/CDROM/
and see sample 1206

Nic;o)
Oct 5 '07 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1918
by: Wayne Aprato | last post by:
I have seen the following problem mentioned here before but have not as yet seen a fix that works. When a chart is opened in form view everything is OK. When a chart based on the same query is opened in a report, sometimes the chart shows the design view data and not the data from the query. If the report is closed then reopened, more often than not it will show the correct data. This is a serious flaw in Access and makes an otherwise...
0
2080
by: spm_no | last post by:
Hi, I am using Access 2002 and am creating a scatter-chart on a form in which the X-axis is a date. I can format and display the x-axis properly as a date. However, when I close and reopen Access, the data are incorrectly plotted with an x-axis that begins with a date of 1900. Only by toggling from the option "chart by column" to "chart by row" and then back to "chart by column", can I get the correct date on the x-axis. The problem...
6
3145
by: Hazz | last post by:
I have been asked what I thought would be a good database design, data delivery mechanism and rendering method for an org chart with as many as 100,000 people. No other design specifications. 1. Database design? Good question. Employee Table EmployeeID EmployeeName ParentNode (BossID ??) Depth(some way to tell what depth the node is at)
2
2726
by: Anil | last post by:
Hello, I am using VS2005 Beta2 and I have added a Simple Line-Graph chart to a ReportViewer control. I can click on the chart and alter for example the Minimum and Maximum scale values of the Y-axis. The question I have is that, can I change these values from within my code and how?
8
2189
by: GaryDean | last post by:
We have been noticing that questions on vs.2005/2.0 don't appear to get much in answers so I'm reposting some questions posted by some of the programmers here in our organization that never got answered... In 1.1 we always did our own myDataAdapter.fills and we liked that control for lots of good reasons. Now the new DataSource (or is it a TableAdapter:Dataset) automatically fills the Gridview. How can we control that fill? In a...
18
8771
by: Marcel Saucier | last post by:
Hello, I want to use the above characters codes chart but I dont know how to set the typeface (documentation: The characters that appear in Windows above 127 depend on the selected typeface). For example, when I print the chr(205), I am not getting the one shown in the Chart 2 list... A step by step approach will be appreciated (in a windows form application). --
8
12462
by: dkelly | last post by:
I wish to create a report with a chart, but I want to use a SQL statement as the source of the data, using VBA code in the reports load event I found the following snippet Dim objGraph As Object, objDS As Object, rsData As Recordset Set objGraph = Me!Graph1.Object Set objDS = objGraph.Application.DataSheet
0
2505
by: Wayne | last post by:
I am charting data from a query that consists of a Date/Time field and a Number field. The Date/Time field is the x scale on my chart. Sometimes data is collected from different times during the one day. I need to be able to see these times as different time points on the x scale of my chart. To accomplish this I am using the following statement as the row source for my chart: "SELECT (Format(,"DDDDD HAMPM")),Max() AS FROM GROUP BY...
0
4017
by: cowboyjunkey | last post by:
This is what I want to do: Each report page will list some details about a sample (like time sampled, where, who sampled) and below it a chart showing the distribution of the sample (i.e. numbers in categories of less than 2 oz, 2-2.5oz, 2.5oz-3oz, etc.) I thought that I could add a chart just like in Excel but either I cannot or am doing something very wrong. In Report Design I click on Design at the top and then Insert Chart
0
9712
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
10595
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10341
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10089
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6862
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5530
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5673
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4308
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3001
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.