Hello All.
It's great to be in a place where people share their knowledge in a frendly way.
It's seem to me unlikely for PivotChart not to have a certain feature. I didn't find it, and looking through the net I couldn't find an explanation.
I have a table with a field of Cities being the Category Axis (X-Axis), a feild of AvgPayments being data Y-Axis with an automatic scale that takes into account the max. AvgPayments value, and a field of AvgDepts being another data Y-Axis (same type but with different, a much smaller max. value) with an automatic scale that takes into account the max. AvgDepts value.
As I build this type of chart, the 2 Y-Axes are built by the chart with the same automatic scale (that which takes into account the max value of both AvgPayments and AvgDepts). Now, if I chage the scale of one axis to a custom number the other scale changes too, not that if it wouldn't change, would help me, as I need 2 automatic different scales for 2 fields.
Anyone knows how to solve this?
Regards.
2 2598 MMcCarthy 14,534
Recognized Expert Moderator MVP
I'm afraid I don't use Pivot tables much.
I'm posting this to move this question back up the list.
Anyone have a solution for this problem. I am having the exact same issue. Is there a way to get around this programmaticall y?
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Tracy Griever via AccessMonster.com |
last post by:
Simple way to change/remove the "Sum of..." text, or any text, in a PivotChart LEGEND. I searched other sites for many hours and could find no help on this subject...a co-worker stumbled upon the soultion.
To change the text in a PivotChart LEGEND, switch from PivotChart View to PivotTable View. Then click once to highlight the field name that reads "Sum of...", then go to properties, when the properties dialog box displays select the...
|
by: Gargamil |
last post by:
I've created a series of Pivotcharts in Access 2002. How do I export the
chart to a GIF? I do it all the time with charts in forms and reports -
can't get it happening in the Pivotchart
g
|
by: windandwaves |
last post by:
Hi Folk
I am trolling Google groups to find info, but so far unsuccessful.
I have a form with in it a subform which is a pivotchart. From the main
form, I have created a control that should filter the pivotchart.
I tried
me.CHILD.form.filter = ...
|
by: Filo |
last post by:
Hello,
Design nice PivotTable or PivotChart (selecting fileds,captions,
colors, fonts, order of fieds etc.) sometimes takes more then 1 hour
and I hate when after this my boss (or I self) ask me to add some
additional field not availible in data source ! :(
I can't update field list of PivotTable to new data source without
blanking all object and I have to do stiupid job again (selecting
fileds,captions, colors, fonts, order of fieds...
|
by: francophone77 |
last post by:
I created a button to open a pivotchart, but each time I click the
button, it comes up in form view and I have to switch the view to
pivotchart view in order to see the chart. Is there anyway around
this?
TIA
| |
by: guaj1818 |
last post by:
was wondering how i can create a pivotchart with 2 or more fields on
the y-axis with a value x axis, e.g. 20-200, interval: 40. i only get
a category x axis when choosing a Line chart. with the XY (Scatter), i
am able to select only one field for the y-axis.
i am using access 2003 project with sql server.
|
by: grgimpy |
last post by:
I have a pivotchart in a tab in my main form. First question: Is there a way to display only a certain number of the most recent records? For example, to limit the pivotchart to displaying only the 20 most recent values. The values have both a time and ID tag on them if that helps.
For my second question: Is there a way to automatically update the pivot chart as the query is also updated? When I enter data into a form in one of my...
|
by: sanniep |
last post by:
Dear Expert,
I would like to program a button to export an Access pivotchart to Excel. The predefined button works ok but I would like to automate it.
Thanks, Sander
|
by: Just_a_fan |
last post by:
Some folks have searched, from time to time, for a dual axis MSChart
with different scales on the two Y axes. The sample, extracted from
running code I wrote, produces a graph with MSChart (VB9) which shows a
time axis on X and two somewhat different value ranges on Y and Y2.
This code produces two axes with positive and negative values, if called
for, and also ranges the Y and Y2 values to match the data and still
remain readable.
...
|
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...
|
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,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
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,...
|
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...
|
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();...
|
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
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...
| |