Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Excel 2007 - percentage and values on 100% line/column stacked charts

Guys,

Here is my problem. As an output of my analysis I have a pivot table
containing 4 columns:
col1 - date; col2 - number_of_successfull_connections; col3 -
number_of_failed_connections; col4 (auto) - total.

Example:
09/01/2007 12 2 14
09/02/2007 32 1 33
09/03/2007 12 9 21
[...]

I would like to create a 100% stacked line or column chart for date
and number_of_failed_connections (to track % of bad connections per
day). In addition, each makrer's label should contain % failure, and
number of connections (example for 09/01/2007 "14%/2")

What really drives me crazy is a fact that neither there is a
"percentage" option in data label menu I can select, nor I can
generate the chart omitting col2.

Is there any way to do this except manual work?

Thanks,
MB

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine Clustered Column Bar charts and Stacked column bar charts Richard Charts and Charting in Excel 1 October 26th 06 02:44 AM
How do I Excel chart 2 stacked values with third value as a line? chartnovice Charts and Charting in Excel 1 August 29th 06 12:58 PM
Line & Double Stacked Charts K Charts and Charting in Excel 1 June 16th 06 06:19 PM
Stacked column, 2 values, percentage? [email protected] Charts and Charting in Excel 1 February 4th 05 12:18 PM
How do I combine a line and a percentage stacked column chart? Liza Charts and Charting in Excel 1 February 3rd 05 01:40 PM


All times are GMT +1. The time now is 01:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"