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 » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 0.33 seconds.
Search: Posts made by: Ed Ferrero[_3_]
Forum: Charts and Charting June 4th, 2010, 06:51 AM Posted to microsoft.public.excel.charting
Replies: 1
Views: 3,155
Posted By Ed Ferrero[_3_]
Making a Bubble Chart with 4 variables instead of 3

Take a look at my BCG Matrix chart
http://edferrero.com/ExcelCharts/tabid/102/Default.aspx

It seems to do what you want.

Ed Ferrero
www.edferrero.com
Forum: General Discussion May 31st, 2010, 06:30 AM Posted to microsoft.public.excel.misc
Replies: 6
Views: 167
Posted By Ed Ferrero[_3_]
Final attempt save as binary question

Hi Kevryl,

I assume you have seen this?
http://blogs.msdn.com/b/excel/archive/2006/07/20/671995.aspx

Ed Ferrero
www.edferrero.com
Forum: Charts and Charting May 20th, 2010, 08:30 AM Posted to microsoft.public.excel.charting
Replies: 2
Views: 363
Posted By Ed Ferrero[_3_]
Seemingly random plot area drift?

Hi MKArchibald,

1. Why does this random movement of the plot area happen? I'll not also
that
the legend also seems to move.

I don't know why this happens. Suggestions are to install all...
Forum: New Users May 12th, 2010, 06:20 AM Posted to microsoft.public.excel.newusers
Replies: 2
Views: 308
Posted By Ed Ferrero[_3_]
Different cell heights within worksheet

Camera tool is your friend...

I'd like to format 4 different cell heights in different worksheet
columns.
When I try to do so either by highlighting a single cell, row or column it
changes...
Forum: General Discussion May 9th, 2010, 02:42 AM Posted to microsoft.public.excel.misc
Replies: 10
Views: 225
Posted By Ed Ferrero[_3_]
Update - Microsoft Responds to the Evolution of Community

James Silverton wrote,

Blah! Can the Microslobs *remove* the news group even if they don't
acknowledge it? People could still post to the group and read it on other
servers.

Correct, nntp...
Forum: General Discussion May 8th, 2010, 12:32 AM Posted to microsoft.public.excel.misc
Replies: 5
Views: 121
Posted By Ed Ferrero[_3_]
Need suggestions on layout to report/pivot

Hi Nadine,

Does anyone have any thoughts on how to arrange this in Excel 2003:

Some thoughts here
http://edferrero.com/ExcelTutorials/ExcelDatabaseTutorialPart1/tabid/90/Default.aspx

Ed...
Forum: Charts and Charting April 1st, 2010, 08:03 AM Posted to microsoft.public.excel.charting
Replies: 2
Views: 338
Posted By Ed Ferrero[_3_]
Change the chart when a cell is clicked

Hi SheriTingle,

I have a sample that pretty much does what you are asking at;
http://edferrero.com/ExcelCharts/tabid/102/Default.aspx

Look for 'Chart Selector' and/or 'Chart Selector Version 2' and...
Forum: New Users April 1st, 2010, 07:54 AM Posted to microsoft.public.excel.newusers
Replies: 1
Views: 305
Posted By Ed Ferrero[_3_]
How do I work in excel and then save it as a doc or docx?

Hi Nadine,

You can open a Word document and Insert - Object - Microsoft Excel
Worksheet

Ed Ferrero
www.edferrero.com
Forum: New Users March 25th, 2010, 08:39 PM Posted to microsoft.public.excel.newusers
Replies: 2
Views: 162
Posted By Ed Ferrero[_3_]
Creating a Graph from a Drop Down List in Excel

Don Guillett wrote,


sure
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"cb" wrote in message
Forum: Charts and Charting March 25th, 2010, 03:12 AM Posted to microsoft.public.excel.charting
Replies: 5
Views: 194
Posted By Ed Ferrero[_3_]
time scale proportional using a column chart - not just for scatte

Hi babs,

Excel can't build a column chart with time as the x-Axis. However it can
build a column chart using dates as the x-Axis.

This suggests a way to fake a column chart that has hours as its...
Forum: Charts and Charting March 19th, 2010, 07:08 AM Posted to microsoft.public.excel.charting
Replies: 5
Views: 156
Posted By Ed Ferrero[_3_]
Can not get Excel macros to save chart format -lost in space!

Hi,

There is a difference in VBA between a Chart and a ChartObject. The latter
is a sort of container for a Chart and can be embedded in a Worksheet.

ActiveChart is a property of the ChartObject...
Forum: General Discussion March 18th, 2010, 05:10 AM Posted to microsoft.public.excel.misc
Replies: 5
Views: 129
Posted By Ed Ferrero[_3_]
How to see full path name of open workbook?

Hi Joe,

=CELL("filename",A1)

Ed Ferrero
www.edferrero.com
Forum: General Discussion March 10th, 2010, 03:48 AM Posted to microsoft.public.excel.misc
Replies: 5
Views: 60
Posted By Ed Ferrero[_3_]
How do I make into a dollar format when in a formula?

Hi krissy,

How do I make the 7897.98 w/ a dollar amount? The current formula is " &
c8
& ".

=TEXT(C8,"$0.00")

Ed Ferrero
www.edferrero.com
Forum: Worksheet Functions March 10th, 2010, 12:21 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 91
Posted By Ed Ferrero[_3_]
Calculating Problem: Desperate :(

Hi cionnaith,

In short, what I need to happen is if all of the entries in the column of
20
cells are 0's the first cell function I described should result in the
number
20. Then I need...
Forum: Charts and Charting March 9th, 2010, 11:24 PM Posted to microsoft.public.excel.charting
Replies: 2
Views: 154
Posted By Ed Ferrero[_3_]
Stack bar charts with positive and negative numbers

Hi Jeannine,

It sounds like you want a waterfall chart.

Go over to Jon Peltier's site and download his utility
http://peltiertech.com/Excel/Charts/NonNative.html#Falls

Or take a look at my own,...
Forum: Worksheet Functions March 8th, 2010, 07:26 AM Posted to microsoft.public.excel.worksheet.functions
Replies: 4
Views: 73
Posted By Ed Ferrero[_3_]
copy drag financial years

Hi Ben,

Hi i use financial years a lot and was wondering if there was a simple way
to
copy, paste/drag the years down a column so they expand? For example when
i
drag the years down i...
Forum: Charts and Charting March 5th, 2010, 12:18 AM Posted to microsoft.public.excel.charting
Replies: 4
Views: 222
Posted By Ed Ferrero[_3_]
One Chart, Same Data ranges, different source sheets

Hi Greg in CO,

The ADDRESS function will accept a sheet name from a cell reference
=ADDRESS(rowNo,columnNo,1,0,SheetName)

Combine this with the INDIRECT function to get the value of the cell with...
Forum: Charts and Charting March 2nd, 2010, 03:34 AM Posted to microsoft.public.excel.charting
Replies: 4
Views: 149
Posted By Ed Ferrero[_3_]
Chart formatting problems (multiple)

Hi WhiskyCast,

A couple of guesses;

Format the cells containing the 'months' to dd-mmm-yy. Do you have months
starting on different days?

Right-click the series. Choose 'Format data Series' from...
Forum: Charts and Charting February 12th, 2010, 04:07 AM Posted to microsoft.public.excel.charting
Replies: 4
Views: 130
Posted By Ed Ferrero[_3_]
Table within a chart

Hi Catherine,

I like your idea of having one text box saying YTD Referral = 25. I tried
it
using

="YTD Referral ="&Referrals!$N$2

I get an error message. Do you know why? How can I...
Forum: New Users February 11th, 2010, 11:50 AM Posted to microsoft.public.excel.newusers
Replies: 8
Views: 356
Posted By Ed Ferrero[_3_]
Paths to becoming an Excel Expert

Hi PBB,

A few thoughts - just my own opinion, you will have to make up your own
mind.

Developing an on-line presence helps, but it it not a prerequisite for doing
Excel consulting.

I would not...
Forum: Charts and Charting February 10th, 2010, 06:09 AM Posted to microsoft.public.excel.charting
Replies: 6
Views: 165
Posted By Ed Ferrero[_3_]
Creating a Line graph

Hi Greg,

Let's try the failsafe way. This should help in understanding what is going
on behind the scenes.

Select an empty cell in your sheet.
Insert - Line Chart you should see an empty...
Forum: New Users February 9th, 2010, 06:01 AM Posted to microsoft.public.excel.newusers
Replies: 3
Views: 73
Posted By Ed Ferrero[_3_]
Report Options

Hi Linda,

....and you may benefit from my Excel Database Tutorial at
http://edferrero.com/ExcelTutorials/ExcelDatabaseTutorialPart1/tabid/90/Default.aspx

Ed Ferrero
www.edferrero.com
Forum: Charts and Charting February 9th, 2010, 05:58 AM Posted to microsoft.public.excel.charting
Replies: 1
Views: 158
Posted By Ed Ferrero[_3_]
can't center a category label on a line chart

Hi Harold ,

Arrange Your data like this;

2008 Q1 0.2 15.70%
Q2 0.2 15.80%
Q3 0.2 16.80%
Q4 0.2 21.40%
2009 Q1 0.3 24.60%
Q2 0.3 26.90%
Forum: Charts and Charting February 9th, 2010, 05:47 AM Posted to microsoft.public.excel.charting
Replies: 3
Views: 153
Posted By Ed Ferrero[_3_]
On scatter chart, how can data points be moved with curser?

Hi Carlos,

You might want to see Microsoft's add-in for this. Still not as good as...
Forum: Charts and Charting February 9th, 2010, 05:40 AM Posted to microsoft.public.excel.charting
Replies: 6
Views: 165
Posted By Ed Ferrero[_3_]
Creating a Line graph

Hi Greg,

Select your data including one column to the left of your data. i.e. if the
data is in cells B1:C3, select A1:C3
Then Insert - Line Chart
Then Switch Row/Column

Ed...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 04:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.