Charts
in [Excel]
|
Charting a variable range Hi, Graphs are not my strong point so in easy steps please. I have a data range of 31 cells and the value in each cell is derived by a formula. Basically if the date in another cell is >today() the formula evaluates as null ("") and if <= today a value is populated. Currently I'm graphing the full 31 cells... 23 Jun 2008 14:48
Turn off font Auto Scale globally in Excel 2003? Is there a way to tell Excel globally to uncheck the Auto scale checkbox on the font tab for all chart elements? Or at least turn it off for all elements on the current chart? The default seems to be to have auto scale on and the only thing I can figure out to deal with it is to turn off each chart element's ... 23 Jun 2008 19:56
Graph colours I have set up an excel file with multiple graphs on one sheet. I seem to have a re-occuring problem where the colours on the graphs change for no reason. I think it is something to do with the pallet setup. For example on my pallet today the bottom right colour is white whereas on Friday it was cream. Subsequen... 23 Jun 2008 21:59
how to: polynomial regression trendline excel 2007 I had a polynomial regression trendline in Office / Excel 2003. I updated to Office / Excel 2007 and the trendline disappeared and I can not get it back. Any suggestions? -- miltstep ... 23 Jun 2008 12:44
Excel 2007 multiple data series charts I have an application that uses three data series. One to display the actual data (x and y values) in a column format and the other two to show "average" values for the whole company (taken from a field on another tab) and for the current data. The actual data it's average is held in a pivot table but the serie... 23 Jun 2008 12:44
Bar within a bar Hi everyone, Want to draw a bar chart where 2nd row values should be drawn within the 1st row values. Given below the data: Dec'07: 24.5 (1st row) 17.45 (2nd row) Feb'08: 30.5 (1st row) 15.3 (2nd row) Jun'08: 24.25 (1st row) 14.27 (2nd row) By default, 24.5 is getting sumed up with 17.45 or otherwise I... 23 Jun 2008 09:38
How to draw a flow chart under Excel? Does anyone have any suggestions on how to draw flow chart under Excel? and Does anyone have any reference on the meaning for different shape of drawing on flow chart? Thanks in advance for any suggestions Eric ... 25 Jun 2008 15:00
3D Charting I have a series of data. Each row is an observation. The first entry (column or field) is the verticle position of the observation relative to an origin, the second entry is the horizontal position of the observation relative to an origin, and the third entry id the value of the observation. How can I (or ... 22 Jun 2008 22:26
How do I set up an automatic calculation by date in Excel? I'm creating a line chart to display the daily progress of a bank account. I have made a basic spreadsheet for the account, with a particular cell (C1) in the first worksheet displaying the account balance. I'd like to arrange the line chart, in sheet two, to update at midnight daily displaying that current da... 22 Jun 2008 05:04 |