A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Charts and Charting Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Do not show a portion of the data series if the value is 0 by asmithbcat
Say I have data as follows Apr-09 May-09 Jun-09 1.00 2.00 2.00 0.00 1.00 1.00 0.00 0.00 2.00 If the quantities I have listed are driven off of formulas, how...
October 21st, 2008 10:06 PM
by Bernard Liengme Go to last post
1 141
Chart format change 2003 - 2007 by ProcessTeam
I have changed from Exel 97-03 to 2007. When I open up reports with graphs that I have created in the earlier version, they appear distorted and have slight...
October 21st, 2008 09:04 PM
by Jon Peltier Go to last post
1 232
Do I really need OFFSET? by bflorox
I have defined a Dynamic Name as follows: =OFFSET(Sheet1!$A$4,COUNTA(Sheet1!$A:$A)-1,0,-MIN(chtLen,COUNTA(Sheet1!$A:$A)-1),1) The label for the data is in...
October 21st, 2008 09:02 PM
by Jon Peltier Go to last post
3 192
Dividing a chart with a horizontal line by Betsy
I have a chart that has 15 vertical items down the side, and measurements across the bottom. I want to add a horizontal line to the chart that will separate...
October 21st, 2008 08:41 PM
by Betsy Go to last post
2 253
Two Headers, one subject column and various columns with data by ILoveMyCorgi
I am trying to create a simple graph chart and get bupkus! The chart consists of: CST RESULTS Subject School District 2005 2006 2005 2006...
October 21st, 2008 05:48 PM
by ILoveMyCorgi Go to last post
5 168
Y Axis by Meejung
I am trying to create an average line using a line chart on an existing chart. When I try to match the values from the Y Axis from my primary request I...
October 21st, 2008 04:00 PM
by Meejung Go to last post
2 83
Create a solution region on a chart by WACKEY
I'm creating a graph of a linear inequality. I have to plot two lines, then show the solution region, or a shaded region between the two lines. So in effect...
October 21st, 2008 08:37 AM
by Andy Pope Go to last post
3 160
Leader lines disappear by BillieJ
I have 3 pie charts, with leader lines to the labels, in an Excel workbook. After I close my file all the leader lines are gone when the file is reopened. ...
October 21st, 2008 02:18 AM
by ShaneDevenshire Go to last post
1 237
Years of Service and Salary Range by cingecdc
I am trying to graph years of service (x axis) and the salary range (y axis), however, I am only able to get a head count for the y axis. What am I doing...
October 20th, 2008 08:57 PM
by ShaneDevenshire Go to last post
1 102
Can excel graphs be set to choose same colour i.e hols = yellow by LyndseyF_UK
I have a weekly task of tracking resource across a large department, therefore numberous graphs. Is there any way to set up excel to select the same colour...
October 20th, 2008 03:34 PM
by ShaneDevenshire Go to last post
3 165
Data changes linked to chart by Jeff Stanton
Is it possible to link a chart and its data table so that a change in the data is automatically reflected in the chart?
October 20th, 2008 04:08 AM
by ShaneDevenshire Go to last post
5 237
How suppress chart points - cells with formulae returning null by sarcastix
I want to suppress chart points for a cumulative line graph of monthly telephone costs where the particular month's values have not yet been entered but...
October 20th, 2008 12:50 AM
by Barb Reinhardt Go to last post
2 129
Using Range Names in Charts by Eli Kedar
I just converted from Excel 2003 to 2007. Whwn I try to use Range Names in charts I get an error "Formula contains invalid references" Please Help -- Eli...
October 19th, 2008 01:57 PM
by Eli Kedar Go to last post
3 148
Printing Arrow in Chart by RM
I am using Excel 2007. I made a line chart with a textbox and an arrow pointing towards the data line. The box prints but not the arrow. I also clicked on...
October 19th, 2008 01:56 PM
by Bernard Liengme Go to last post
1 149
Color change on bars when goal met by wgnewman
How do you have a bar change/begin a new color when the total reaches and surpasses a goal/target? For example, if a series has totals above and below a...
October 19th, 2008 12:51 AM
by Bernard Liengme Go to last post
2 161
How can I enter time in Excel in 10:15:10:02 for sport timing ? by Mathias
I Like to enter sports times in a excel sheet with tens off a secound how can i do that?
October 18th, 2008 09:09 PM
by ShaneDevenshire Go to last post
4 127
Graphing the maximum and minimum values by easymac
Hi, everyone. Let's say I have two columns. Column A has the first ten letters of the alphabet, each listed 4 times (A1=A, A2=A, A3=A, A4=A, A5=B, A6=B,...
October 18th, 2008 05:55 AM
by arshad malik Go to last post
7 241
Excel Charts in Word - adding rows by jennifer
I have an excel chart (of a balance sheet). On 2 different pages in Word using the same worksheet, I pasted the first section (assets), which contains 10...
October 18th, 2008 01:43 AM
by ShaneDevenshire Go to last post
1 161
Superimpose one chart on another by Kirsten
How do I superimpose one chart onto another so that I can see all of the data in both charts? One is a scatter graph and the other is a line graph using...
October 18th, 2008 01:41 AM
by ShaneDevenshire Go to last post
1 136
Do not sort data alphabetically in a Pivot table by Denise
I entered employee names in a worksheet, along with hours worked on projects. When I create the pivot table it rearranges the names alphabetically. Is...
October 17th, 2008 08:10 PM
by ShaneDevenshire Go to last post
1 126
Post New Thread


Display Options
Showing threads 2901 to 2920 of 15904
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


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