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
Please help - Runtime Error 13 on graphs by Sandra
On one of our workbooks we have several graphs that pull information from the other worksheets within the workbook. When I click on the tab (worksheet)...
May 27th, 2004 05:54 PM
by Jon Peltier Go to last post
9 342
Too many data points by Cowtoon
I have data that's collected every two minutes, 24 hours a day and only want to chart the data for every hour (on the hour). How do I extract...
February 24th, 2005 10:13 PM
by Tushar Mehta Go to last post
9 276
Save excel chart by Stevie D
Hi I have two related questions, 1) Is it possible to select an excel chart and save it as a separate object that is that independent of the workbook it was...
March 3rd, 2005 02:18 PM
by [email protected] Go to last post
9 247
Zero Values in a Pie Chart by DMc2005
Hi I currently have some data as shown below: Item 1 0 Item 2 3 Item 3 6 Item 4 5 Item 5 0 Item 6 9
April 2nd, 2005 04:41 AM
by Jon Peltier Go to last post
9 138
waterfall chart ... once again ... by SIGE
Hi There, I am trying to get the famous waterfall chart to work for my data. For 2 days now I have been reading and creating dummy...
May 1st, 2005 03:28 AM
by Jon Peltier Go to last post
9 173
up down bar value (difference) by Basil
Hiya, I have a line chart with two lines. I have included down bars from the upper line. I would like the difference of value between the two lines (i.e....
May 20th, 2005 10:14 PM
by Jon Peltier Go to last post
9 295
Function for Logarithmic Trendline by ArthurJ
I have been using the trendline - logarithmic type - on some charts. Although the equation in the form y = a*ln(x) + b can be made visible on the chart, I need...
June 8th, 2005 12:08 AM
by ArthurJ Go to last post
9 535
Excel option to store trendline's coefficients in cells for use by Miguel Saldana
I believe it will be useful to add an option to Excel that when adding a tendline to a graph, Excel could ask in which cells it will store the coefficients and...
June 20th, 2005 08:45 PM
by Tushar Mehta Go to last post
9 945
Auto color-shading of rows by Fitz
Can I automate an excel worksheet such that if ,say, "436" is written in a certain cell it shades that row yellow, or if "437" is in that cell it shades the...
November 27th, 2005 02:11 AM
by Adrian Go to last post
9 144
Is there some way (event) to know when an embedded chart is deleted? by [email protected]
I am looking for a way to trap the case when an embedded chart is deleted. I already have a chart Event class setup and am currently handling Calculate...
February 11th, 2005 04:26 PM
by Andy Pope Go to last post
9 155
Polynimial trandline formula by CLR
Hi All........... I'm not much into higher math, or charting myself, but one of my users has drawn a Scatter Chart and added a third order polynomial...
February 7th, 2005 08:31 PM
by CLR Go to last post
9 339
Deleting charts by maxfoo
I'm trying to use an example in John Walkenbach excell2000 pp w/vba book on deleting charts: 'ActiveWorkbook.Charts.Delete' I have about 100 sheets that have...
May 29th, 2004 01:37 AM
by Anders S Go to last post
9 213
Interactive XY Scatter chart by K. Georgiadis
I have created an interactive XY scatter chart, driven by a drop down box, whereby the use of the INDEX function determines which of the 15 different...
June 8th, 2004 08:23 PM
by Go to last post
9 289
Adding a second line on a two axis column stacked chart by JC
I have a stacked bar graph showing 4 data series on the x- axis with a line showing 1 data series on the secondary x-axis. Now I want to add a second line to...
August 31st, 2004 04:43 AM
by Jon Peltier Go to last post
9 215
Timeline Chart? by Jamie
I have certain employees that will clock in and out and various times throughout the day. The total day runs from 8:00 am - 5:00 pm. I want to be able to...
March 17th, 2005 10:20 PM
by Jon Peltier Go to last post
9 206
Named dynamic ranges, copied worksheets and graph source data by CNUK
I have a worksheet setup that graphs data contained in two dynamic named ranges. The graph is an object within the worksheet and not a separate graph sheet. ...
November 28th, 2004 06:19 PM
by R.VENKATARAMAN Go to last post
9 187
Creating a dynamic chart by Fysh
I posted here a few days ago and was given some ideas on how to do this. However, I seem lost. I have a main worksheet which is updated from...
December 15th, 2004 03:52 AM
by Jon Peltier Go to last post
9 284
Cell value as chart scale maximum by Phil Hageman
I have a chart on a worksheet and want to make the Y scale maximum value equal the value of cell Y3 (this is a merged cell range Y3:Y5), rounded up to the next...
December 17th, 2004 03:09 PM
by Tushar Mehta Go to last post
9 248
Least number of digits in Y-axis labels by Charley Kyd
I'm looking for an automatic way to format the value axis with the least number of digits possible after the decimal. I want the format to switch from #,##0 to...
February 6th, 2005 04:03 PM
by Charley Kyd Go to last post
9 283
Create a Graph with Random Number Generator by Luke Williams
Hello, I'm trying to reproduce a graphic. It was made using the random generator number. Since, I am not very confortable with statistics I thought...
December 19th, 2005 07:42 PM
by David Biddulph Go to last post
9 234
Post New Thread


Display Options
Showing threads 161 to 180 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:31 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.