PC Review


Reply
Thread Tools Rate Thread

Creating a pivot chart

 
 
=?Utf-8?B?UG93ZXJQb2ludCBKZWRp?=
Guest
Posts: n/a
 
      31st Oct 2006
Hello,
Not sure where to post this as there is not a chart group and I have a
question about pivot charts I am hoping to get answered.

First off I am runnign Microsoft Access 2003.

Second I have created a Pivot chart to plot the number of failures in a year
for a bunch of different parts. The catogory axis (y) is comprised of the
different part numbers and the data field is the number of failures in a
year.

The question is:
If i have produced 100 units over the course of the year how can I show the
percentage on the chart. I would like the number of failures to be listed as
a data label and the percentage to be the x-axis. Thank you
 
Reply With Quote
 
 
 
 
Pieter Wijnen
Guest
Posts: n/a
 
      1st Nov 2006
you should be able to do that by editing the chart (double click in design
view etc.)
Remember that Charts are "native" to excel, so mimicking the data in excel
may help you more

Pieter

"PowerPoint Jedi" <(E-Mail Removed)> wrote in
message news:C8CB7531-3EE1-4165-B440-(E-Mail Removed)...
> Hello,
> Not sure where to post this as there is not a chart group and I have a
> question about pivot charts I am hoping to get answered.
>
> First off I am runnign Microsoft Access 2003.
>
> Second I have created a Pivot chart to plot the number of failures in a
> year
> for a bunch of different parts. The catogory axis (y) is comprised of the
> different part numbers and the data field is the number of failures in a
> year.
>
> The question is:
> If i have produced 100 units over the course of the year how can I show
> the
> percentage on the chart. I would like the number of failures to be listed
> as
> a data label and the percentage to be the x-axis. Thank you


--------------------------------------------------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 5402 spam emails to date.
Paying users do not have this message in their emails.
Try SPAMfighter for free now!


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I keep formatting when creating a chart from a pivot? Kevin Microsoft Excel Charting 1 15th May 2010 06:01 AM
RE: Creating a pivot chart in vba? Luke M Microsoft Excel Charting 0 21st Sep 2009 04:20 PM
Creating a Pivot Chart D_Zsol Microsoft Excel Charting 0 22nd Oct 2008 06:12 PM
Creating a Report from a Pivot Chart =?Utf-8?B?U2N1ZGE=?= Microsoft Access Reports 0 17th Oct 2006 05:57 PM
Creating One Chart from two Pivot tables combining X axis Michelle Microsoft Excel Charting 0 21st Apr 2004 08:47 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:25 AM.