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
Crossing to New Year in Source Data by Susan H.
I have a chart based on attendance for the school year. It goes from 9/09 to 6/10. I have my data source chosen for the entire time frame, but the chart is...
January 25th, 2010 09:12 PM
by trip_to_tokyo[_3_] Go to last post
1 135
NA in Line chart plotting as zero by Barb Reinhardt
I'm using Excel 2007 and the line charts with NA are plotting as zero. I suspect there's a setting I need to change, but I just can't find it. Can someone...
January 25th, 2010 08:40 PM
by ymgagnon Go to last post
3 230
Swapping headers by Darren
Is there a way to swap the column and row names so that I can click/drag ascending nunbers horizontally and letters vertically?
January 25th, 2010 07:51 PM
by Darren Go to last post
2 155
Surpressing plot of blank cells by John
I'm creating a line chart plot using Excel 2007. The data range for plot lines contains some blank cells. These blank cells get plotted as zero points. ...
January 25th, 2010 06:36 PM
by ymgagnon Go to last post
4 194
Axis Numbering Question by Bob[_62_]
Hello, Using Excel 2007 and Windows 7. Let's say I have a chart with vertical axis tick marks every 10 units. However, my grid lines are every 20 Units, and...
January 24th, 2010 10:58 PM
by Xt Go to last post
2 159
Add-in for More-Sophisticated Charts by Jay
I need to create charts that are more sophisticated than what Excel offers. Are there add-ins or supplementary charts packages (either from MicroSoft or...
January 24th, 2010 06:49 PM
by Herbert Seidenberg Go to last post
3 180
Connect bars in a column chart by I Teach
I would like to connect the tops of columns with a line in a multi-column chart so that the line shows something like a trendline for the series. Trendlines...
January 24th, 2010 05:08 PM
by Herbert Seidenberg Go to last post
4 210
double category by Carina L
I have a chart with double categories, the year plus the question in the survey. I want to format the categories separately, for example with different size...
January 24th, 2010 05:01 PM
by Carina L Go to last post
0 97
Creating a Chart from Cells that use a List Box by adrian007uk
Hi, I am trying to create a number of charts (e.g., pie, line etc) based on data that is slelected from a list box (i.e., data validation). What i would...
January 24th, 2010 03:21 PM
by adrian007uk Go to last post
0 96
Hide data labels with "0" values by Roachie
Some of my source data contains cells with "0" values that I don't want to show on my chart. How can I get them to now show up? I need to leave those ...
January 23rd, 2010 04:44 PM
by Bernard Liengme Go to last post
3 169
Chart Relative To Worksheet When Copying- Excel 2007 by Grace
I'm looking for a technique to make charts automatically reference data on the current worksheet when I copy a worksheet containing a chart. In Excel 2007,...
January 23rd, 2010 07:03 AM
by Héctor Miguel Go to last post
1 195
Banded chart with Trend by Jul B.
I have several sets of data more complicated but similar to below where I'd like to chart the best Dept on the upper line, the worst dept on the lower line,...
January 23rd, 2010 02:32 AM
by Jul B. Go to last post
0 69
Connection Lines Between Data Points by CLR
I'm trying to show connecting lines between data points. X axis is in dollars for the days of the week, Y axis is date. I do not have figures for each day...
January 22nd, 2010 08:43 PM
by CLR Go to last post
2 144
Excel 2003 Charts - color changing by Maureen D.
I have a chart that I update - adding a line, etc., and when I do this the entire color scheme changes. I cannot have this as I need all of my charts in the...
January 22nd, 2010 06:16 PM
by Maureen D. Go to last post
1 124
Pivot Chart Legend editing? by srpd
How can I edit the legend in a Pivot Chart in Excel 2007? Or, if thats not possible, can I edit the data titles in the values field? Ex: the field is titled...
January 22nd, 2010 06:09 PM
by srpd Go to last post
2 136
Data points by Bill Mc
In 2003 I could grab a data point on the chart and move it causing the value in the data table to adjust to match the position on the chart. Is this...
January 22nd, 2010 04:07 PM
by Bernard Liengme Go to last post
3 200
Separating equal values by Darren
Using the large function I can generate a list of high to low values. example: In column E1 -...
January 22nd, 2010 02:38 PM
by Bernard Liengme Go to last post
3 111
today line on graph by Fluke[_2_]
Hi I have a graph with dates along the bottom up to about July this year. Along the 'y' axis is a set of figures up to around 9000 ish. There's 2 sets of...
January 22nd, 2010 01:05 PM
by David Biddulph Go to last post
1 108
Multiple Charts-Multiple Tabs by Nick Anderson
I have multiple charts on multiple tabs within an excel worksheet. Is there anyway to source those charts to the tab name without resourcing the charts...
January 21st, 2010 09:13 PM
by Bernard Liengme Go to last post
1 168
Better, More Sophisticated Charts & Graphs by Jay
Excel does not seem to allow the sophisticated level of charting and graphing that I need. What add-ins from Microsoft or other companies, if any, should I...
January 21st, 2010 11:17 AM
by Martin Brown Go to last post
2 126
Post New Thread


Display Options
Showing threads 521 to 540 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 05:41 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.