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 Replies Reverse Sort Order Views
constant value in a chart by Renaud_D
Hello, How can I display a constant value as a line in a chart? For example, let's assume that I track a variable x across time with n values. In...
November 28th, 2009 06:33 PM
by Jon Peltier[_2_] Go to last post
4 301
Manual sort in a pivot chart/pivot table by Isabel
My goal is to change the order of 4 row lablels. They are all text, and I have to choose the order (not alphabetical). I got as far as clicking on the arrow...
November 5th, 2009 02:48 PM
by Isabel Go to last post
4 426
Adding Lines And Boxes, etc. To A Chart ? by Robert11[_3_]
Hello, Will blame it on my age. Using Excel 2007 (or, at least trying to) and XP. When I have a chart page opened up, how do I get it to show the bar on the...
October 17th, 2009 12:57 PM
by Robert11[_3_] Go to last post
4 213
Pivot Chart- 2 unrelated series on 1 chart by toby131
I have a set of warranty orders that each have a date when the product was originally shipped and a date when a problem was reported. I am trying to make a...
October 23rd, 2009 05:05 AM
by Herbert Seidenberg Go to last post
4 194
combining two cell values to one value to chart by SteveZmyname
Hello While making a chart I wish to combine two values from two seperate cells to make one value to send to a chart. In this case it is the values for the...
October 28th, 2009 03:28 PM
by David Biddulph Go to last post
4 171
Formatting of Data Labels in Histograms by hans L
I have used histograms extensively in MS2003 but have encountered a broblem using MS2007. I have a spreadsheet that shows dollar amounts of contracts being...
November 5th, 2009 08:02 PM
by Jon Peltier[_2_] Go to last post
4 253
Charting by Pippo24
Does anyone know how to create a stacked chart with clustered data? I have 5 products that have promotion and sales budgets. I would like to stack the...
November 12th, 2009 10:27 AM
by Andy Pope Go to last post
4 177
Excel 2007 option by DPingger
The display option for charting 0 values is fixed on Zero; the gap option is grayed out. How do I get this fixed or is there a step I'm missing?...
November 13th, 2009 08:36 AM
by Andy Pope Go to last post
4 131
Dynamic Chart with Defined names by Nils
Hi, I have set up defined names for a range of data, for example "dates" :- =OFFSET(Data!$A$1,COUNTA(Data!$A:$A)-22,0,22) and I have set the series of the...
November 19th, 2009 08:57 AM
by Nils Go to last post
4 131
Remove a column but not data table entry by ClaireP
Hi there, I have a column chart in Excel with 5 columns plotted and a data table below to show the values. I would like to remove 2 of the columns from the...
October 9th, 2009 06:32 AM
by Tushar Mehta Go to last post
4 114
Custumize Chart Tittle Description by Maperalia
How can I make the Chart Tittle to be equal to a specific cell located in one sheet. For example, I have a description on the cell "D10" located in the...
October 7th, 2009 04:22 AM
by Maperalia Go to last post
4 199
column charts on two axis by Jo
I am trying to show a column chart on 2 axis. I have chosen the combination line and column chart to get the 2 axis but when I change the line to a second...
October 28th, 2009 07:36 PM
by Jon Peltier[_2_] Go to last post
4 275
patternfill addin Excel 2007 by Roland
I have used the Patternfill addin from Andy Pope successfully on my homePC with only one user (btw thanks Andy !). When I installed this addin on a multiuser...
September 26th, 2009 11:13 AM
by Andy Pope Go to last post
4 928
How to eliminate zero values on graphs when formula calculates 0? by sjgolfer
I'm setting up a graph of data that is calculated with an "if" function over a series of days of input data including future days. When the input data cell...
September 21st, 2009 07:26 PM
by Bernard Liengme[_2_] Go to last post
4 218
Problem when trying to change source data by Beverly Darvill[_2_]
I have a lot of charts that holds data from 3 years at the current moment in time. At the moment the chart displays the data from Oct 08 to Dec 09 and I...
October 1st, 2009 03:19 PM
by Beverly Darvill[_2_] Go to last post
4 253
Position of X axis labels by K_Macd
I have a graph that shows both negative and positive variances on the y axis. Therefore the zero value axis runs thru the centre of graph and if one wants to...
September 29th, 2009 03:22 AM
by Jon Peltier[_2_] Go to last post
4 168
Skipping Text Entries by Gingerly
One of my charts contains "N/A" entries. Right now they are showing as zeros on the chart. I went to OPTIONS/CHART and the chose the LEAVE GAPS choice but...
September 28th, 2009 05:34 PM
by Gingerly Go to last post
4 167
how to locate a point on excel graph? by logetic
just in graph ,and o not use trend analysis, or that stuff
September 30th, 2009 08:53 AM
by Misange Go to last post
4 169
Secondary Axis Data Series "Clumping" by Mike
I have a chart that has 3 data series. 2 are related to percentages and are tied to the primary axis. The third series is a whole number, and tied to the...
October 6th, 2009 02:58 AM
by Jon Peltier[_2_] Go to last post
4 247
Stacked Charts by Neil Holden[_2_]
Hi all, i need some help creating a stacked bar chart in excel. I want to lay this out in quarters so Quarter 1 will be Turnover and Target two charts but...
November 20th, 2009 07:36 PM
by trip_to_tokyo[_3_] Go to last post
4 237
Post New Thread


Display Options
Showing threads 2181 to 2200 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 10:19 AM.


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