473,592 Members | 2,921 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Formating Legend in an Access Chart

Hello All,

Is there a way I can format the order of legend in an Access chart?

Thanks,
Richie

Sep 7 '06 #1
1 4137
Richie wrote:
Is there a way I can format the order of legend in an Access chart?
If you are talking about the order in which the items displayed in a
legend appear, I have not been able to do this directly. What you have
to do, instead, is write your graph object row source SQL/query such
that you get the aggregated records in the order you wish.

ONe of the common areas I run into with this is the order in which
months appear.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me
Sep 7 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
3161
by: Jorl Shefner | last post by:
I have a problem that I run into a lot with the 'legend' command's default behavior. I've found a work-around but I wonder if there's a better way. For a simple example, take the following: ________________________________ x= a= b=
0
2998
by: Anne van Kesteren | last post by:
Ok, here it goes. Originally I submitted this proposal to www-style. Since I don't get feedback there, I think I missed a few (maybe a lot) of points. Proposal: <http://lists.w3.org/Archives/Public/www-style/2003Nov/0096.html> (for some strange reason I can't post to that list myself) The first point I missed was of course that CSS3UI is not planning to do anything with FIELDSET and LEGEND
0
1756
by: DAL | last post by:
I have created a Pivot Chart that Graphs our orders per month and what type of order they are, either Custom or Standard. To get the data we use an input Form the uses a Combo Box to choose either Custom or Standard when inputing. Wehn I pull up the report with the Pivot Chart, the legend shows a value of "1" for the Customs, and "2" for the Standards, The values from the Combo Box. How can I change the legend to read the Custom /...
3
3414
by: StBond | last post by:
Hi everyone, I am new to Access and Visual Basic so things my be getting across a bit cloudy. I only started using VB for one week. I am having a little problem with the database that I am working on. I am working with MS Access 2002. And I am having a problem with one of my charts. I will explain how everything is laid out then go into details.
0
2074
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...
0
1455
by: Serial # 19781010 | last post by:
I am using VB.NET 2003 with the distributed Crystal Reports 9.0. I have a report that I am putting either a 3D bar graph or pie chart on. The values are based on grand totals. But in the legend I am getting "Sum of tblFiscal.BasicRate", "Sum of......", etc. Since this is not very clean for the user, how can I get the legend label changed to something that makes sense to the user? I have been looking at the code, but not sure where to...
1
2428
by: Rob | last post by:
Hello; I searched and could not find a solution. DOes anyone know how you can actually have the Chart Legend reflect your report/table? I am using a simple two column table like this to test out graphing abilities of the cr graphs year sale 1993 50
0
2370
by: Bon | last post by:
Hello guys Could anyone give me some hints on writng vba code for deleting legend with zero value. My chart is just shown percents There is a legend shown on the right hand size. I used the following lines to remove a pie chart with zero percent. Set objChart = Me.oleLatestGraph.Object
1
6621
by: Wedgewood | last post by:
Group, I am trying to build a gantt chart in a MS Access for but I can't seem to get it to pick up the second data series. In excel, you create a stacked bar chart using fields "Key Date" and "Durration". Once the chart plots you "hide" the "Key Date" field. In Access I can create a bar chart and then goto "Chart Type" and change the chart from bar to stacked bar. That's where it gets stuck because it will only include one data...
0
7935
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
7871
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8227
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
6642
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
5735
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
3851
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
3893
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2379
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
1
1467
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.