473,326 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Pivot Chart Legend

DAL
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 / Standard values
instead of the numerical values.
Nov 12 '05 #1
0 1745

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

Similar topics

2
by: Dave | last post by:
I'm trying to follow the examples in VBAGRP9.CHM and/or VBAGR10.CHM with no success. I'm trying to Chage the Legend Colors based on Content so that I can establish a certain color format on...
1
by: rkbnair | last post by:
I created a pie chart in an aspx. However, how can I display the data in the piechart itself in the right location? The code is as follows: (Please see the definition of float x and float y) ...
1
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...
3
by: GoalieGW | last post by:
Does anyone know how to create a Pivot Chart at run-time? I have a database of meter readings that currently requires me to have 200 forms created so the user can enter date criteria and have a...
1
by: mike11d11 | last post by:
I was wondering if it was possible to export information from a pivot chart when double clicking on the item I want. For example I have a pivot chart with Four items in the legend and they are...
1
by: devagupt | last post by:
i have a form called get downtime data. WHen information is entered into it and the button "get downtime data" pressed , it displays the results of a query. WHen i view the query in pivot chart view...
1
by: thomas.wordsworth | last post by:
This is a bit of a two-part question. 1. Is there a way to control what filters are placed on a pivot chart via vba. I can easily change the underlying query and refresh pivot chart but it's...
5
by: fd1 | last post by:
Hi All, I created a pivot chart using Auto Form Pivot Chart. I'm trying to get to the RowSource query behind my chart but can't seem to locate it. I need to change the legend text. Any ideas? ...
0
by: inepu | last post by:
Is there any way to show a field in a pivot table/chart that is calculated based on other fields of the pivot? I have the following table: Date; DescriptionField_1; Slots; EmptySlots I want...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.