Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default multiple data in one graph

What i have to do is to draw a line graph showing the amount of errors over
time. I have to seperate them into all, answered(which is part of all), any
solved(part of answered). and i can't figure out a way to do it.
Additionally they are supposed to add up: eg if i was to monitor the errors
per month over one year and i had 10 errors each month i dont want a straigt
line at 10, but i want a slope up to a 120 at the end of the year. reason i
cant use the add function in the pivot chart is, that i have to se the count
function already to get the amount of errors during the corresponding month.
Any help would be appreciated

Simon
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
graph data from multiple worksheets dave Charts and Charting in Excel 2 April 12th 07 04:02 PM
Graph using data from multiple files my Charts and Charting in Excel 3 January 5th 07 02:07 AM
graph multiple data ranges lindy.coyle Charts and Charting in Excel 1 November 11th 05 01:46 AM
How do you set all graph data points to black (multiple series)? DamnKiwi Charts and Charting in Excel 1 September 1st 05 01:00 PM
Can you have an multiple XY graph in Excel? Mirjam Charts and Charting in Excel 1 August 31st 05 07:34 PM


All times are GMT +1. The time now is 12:56 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"