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
count number of times a word appears in a column by Tushar Mehta
In XL help, look up COUNTIF -- Regards, Tushar Mehta MS MVP Excel 2000-2004 www.tushar-mehta.com Excel, PowerPoint, and VBA tutorials and add-ins Custom...
November 15th, 2003 12:23 AM
by Tushar Mehta Go to last post
0 627
can I hide a series in a stacked bar chart but keep the series in the data table by Stephen Bullen
Hi, I've got a stacked bar chart with a data table. I'd like to show information in the data table that I don't want displayed on the chart. ...
December 5th, 2003 10:53 AM
by Stephen Bullen Go to last post
0 587
Lines in graph only if values in fields by Jon Peltier
Hi Vitor - Have your user change his formula to =IF(P6=0,NA(),1-(P9/P10)) The "" is an empty string, which Excel interprets not as a blank, but as a bit of...
December 5th, 2003 05:24 PM
by Jon Peltier Go to last post
0 515
Pie Chart - Conditional Color by JAM
Hello. I am trying to create a pie chart with 10 labels each linked to a cell of the same value, so the pie pieces are of a uniform size. I would like to know...
December 5th, 2003 05:46 PM
by JAM Go to last post
0 155
Organizational chart by Patricia
I am looking for aprogram to download i am doing a project and I need to make an organizational chart the one I heard of was called "inspiration' it had some...
December 6th, 2003 05:56 AM
by Patricia Go to last post
0 197
VIRUS W/32/Spybot.gen.worm by JZJT
Es el virus W/32/Spybot.gen.worm
December 9th, 2003 09:06 AM
by JZJT Go to last post
0 69
Pie in pie, but how to NOT show the sub-pie? by paris3
I want a pie chart that just summarizes a set of small-value categories into "OTHER" but without a separate pie chart. In other words, the pie chart shows the...
December 6th, 2003 12:40 PM
by paris3 Go to last post
0 81
Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer" by VJ
You may download the free books and software from http://www.vgupta.com (offer good till Dec 31 2003) Excel For Beginners Charting in Excel Excel- Beyond the...
December 11th, 2003 09:01 AM
by VJ Go to last post
0 392
Lines in graph only if values in fields by Vads
Dear readers, I've got a challenge for all. Working at a helpdesk, I've got a question from an user regarding the following situation. User has a sheet with...
December 5th, 2003 03:21 PM
by Vads Go to last post
0 251
Pivot Chart Bar Width by Jon Peltier
Pat - The bars are based on a percentage of the spacing between categories. If you have fewer categories, the bars get wider. If you decreased the bar width...
December 2nd, 2003 02:43 PM
by Jon Peltier Go to last post
0 231
Using string data to create charts? by kat
We just did something similar in my statistics class. In order to simplify the information, we assigned a numeric value to each word - this allows you to run...
December 1st, 2003 09:18 PM
by kat Go to last post
0 238
Select data series but can't select Add Trendline feature by Chris
I need to add a trendline to a line chart with one data series. I select the data series, but the Add Trendline option is faded on the Chart dropdown menu and...
November 19th, 2003 08:12 PM
by Chris Go to last post
0 466
Help with Data (Table) below my chart by Jon Peltier
Sharon - It's nearly impossible to align the data in the worksheet with the plotted points, but at least they can be in the same relative positions. I've...
November 20th, 2003 03:36 PM
by Jon Peltier Go to last post
0 569
Properly formatting Dates on the X axis by Jon Peltier
Robert - You can achieve the first objective if you make a Line chart, with a Time-Scale axis (Chart menu Chart Options Axes tab Category Axis Time...
November 20th, 2003 06:27 PM
by Jon Peltier Go to last post
0 373
Plotting a datapoint on an existing Line chart by Tushar Mehta
Parallel discussion: http://www.mrexcel.com/board2/viewtopic.php?t=69951 -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint,...
November 23rd, 2003 01:08 AM
by Tushar Mehta Go to last post
0 893
Sectioning a single plotted line into multiple colors by Tushar Mehta
Suppose your data are in A1:A20 and you want A11:A20 to be a different color from the first part of the range. Move A11:A20 to B11:B20. Plot A1:B20 as two...
November 20th, 2003 12:19 AM
by Tushar Mehta Go to last post
0 423
Charting Date Ranges by Jon Peltier
Enig - Your data should be Campaign Start, and Duration (which is Ad Order Close minus Campaign Start). Plot this data the way you already have, but in a...
November 25th, 2003 05:25 PM
by Jon Peltier Go to last post
0 258
Source Data Ranges in Charts by Tushar Mehta
If the data set for each event is contiguous (i.e., no gaps in between the start and end cells), you could use the concept in the Excel | Tutorials | 'Dynamic...
November 30th, 2003 03:29 PM
by Tushar Mehta Go to last post
0 725
Excel Charting - Pareto diagrams by Philip
I'm doing statistical control and have a proces that can go wrong via 13 different causes. I'd like to plot this info monthly as a series of disconnected boxes...
December 1st, 2003 05:00 PM
by Philip Go to last post
0 220
Pivot Table from data table (not data LIST) by Tushar Mehta
As far as I know, the PT requires the data to be in a form compatible with the prerequiste for a relational database model. What you describe is not an...
December 13th, 2003 05:23 PM
by Tushar Mehta Go to last post
0 605
Post New Thread


Display Options
Showing threads 41 to 60 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 09:07 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.