Charts and Charting - Page 756

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.

Thread / Thread Starter	Last Post	Replies	Views
creating a gantt chart automatically by Sue W I have a table that gets imported to Excel that has project numbers, begin and end dates. I want to be able to create a gantt chart for this automatically on...	February 6th, 2004 09:04 PM by Debra Dalgleish	3	302
linking in Excel by Steve Kay Hi, I have a large excel file w/ 20 worksheets and charts. I like to make a Table of Contents at the begining (first worksheet) w/ links to different...	February 6th, 2004 09:01 PM by Debra Dalgleish	1	100
Static Range, Dynamic Chart Data by Jon Peltier Bob - This formula won't plot a zero point: =IF(A1=0,NA(),SUM(A1:A6)) - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services	February 6th, 2004 08:42 PM by Jon Peltier	1	411
Import Charts into Powerpoint by Squid I have created an Excel workbook that contains over 100 charts. Now I want to import these charts into Powerpoint. What would be the most efficient way to...	February 6th, 2004 08:35 PM by Jon Peltier	1	197
Need to return "Blank" cell but NOT NA() by Eric For my chart, I need to return the equivalent of a truly "blank" cell. The NA() function causes the graph to interpolate the missing point, whereas a blank...	February 6th, 2004 08:34 PM by Jon Peltier	1	294
Change default graph colors by Jon Peltier There are two approaches. First, make a custom chart style. Make a chart with all the formatting you like, then choose Chart Type from the Chart menu, choose...	February 6th, 2004 03:47 PM by Jon Peltier	0	515
state maps in Excel by Tushar Mehta I suspect, though I am not sure, that you will have to buy MS MapPoint or one of its competitors to get what you want. -- Regards, Tushar Mehta, MS MVP --...	February 6th, 2004 02:54 PM by Tushar Mehta	0	299
charting date and time data (every minute type) by econair hello i have a minute by minute data of certain measurements, which i wouldlike to go on my x-axis with the y-axis being the measurement value. this data goes...	February 6th, 2004 02:30 PM by Tushar Mehta	1	411
Creating Bubble Charts by tina How do you create a bubble chart that displays the legend as a description of the 3rd variable (the bubble size)? For example, how would you create the...	February 6th, 2004 12:02 PM by Frank Kabel	1	304
Trendline equation not giving correct results by Sudhanshu I was trying to form a trendline with following data : Y X 1.128 -20 1.128 -15 1.128 -10 1.128 -6 1.111 -5 1.084 0 1.056 5 1.0276 10	February 6th, 2004 12:25 AM by Jerry W. Lewis	5	346
Box and Whisker Charts by Kwalters Has anyone ever made one?	February 5th, 2004 11:03 PM by Jon Peltier	1	137
truncation of y axis labels or "value axis title" by Rick Excel 2000 When I add a y axis label to a chart, the last character or two are truncated on the label. I can't increase the size of the title box with the...	February 5th, 2004 05:46 PM by Jon Peltier	1	295
Updating Chart Titles from Spreadsheet Cells by karloff I'm using Excel 2002 and I want to be able to have the titles in my charts update based on entries in the associated spreadsheet. On a monthly basis I import...	February 5th, 2004 05:34 PM by Jon Peltier	4	373
Trendline and its referencing / linking to a cell by MikeG -----Original Message----- PLEASE HELP I have not been able to receive help. Probably the question may not be clear. I am once again putting up the...	February 5th, 2004 03:17 PM by MikeG	0	324
Chart Linked to Other Workbook Not Updating by Michael W. This problem has vexed everyone in our office for over a year. After searching the knowledgebase, a call to MS support proved useless. The support person...	February 5th, 2004 01:44 PM by mcwister@	2	485
Adjust scales automatically by Nicole Hi, How can I arrange it so that the x and y axis scales automatically adjust to different data within the same series? Eg say I make a chart that has the x...	February 5th, 2004 12:44 PM by Tushar Mehta	2	162
Display Month in a label driven from data series by Bill Can an independent label have a formula reference that looks at a particular cell and displays that value?. I am importing data on a monthly basis, that over...	February 5th, 2004 03:29 AM by ChasGo	3	367
Changing a series' Name, X- and Y-values by using its series number by L Mehl I can change the name, X- and Y-values in series #1 with the following code: ActiveChart.SeriesCollection(1).Name =...	February 4th, 2004 01:32 PM by Jon Peltier	4	328
Area chart with vertical lines by Andy Pope Hi Rachel, Take a look at my Averageline example, there is a section on adding lines to an area...	February 4th, 2004 12:35 PM by Andy Pope	0	317
Fixing Cart Data Range by Frank Kabel Hi one way: define a name (goto 'Insert - Name - Define Name'). e.g. the name: chart_range: =INDIREKT("A1:A10") to chart the first 10 rows of column A and use...	February 4th, 2004 10:45 AM by Frank Kabel	0	160

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed