Click in cell w/ formula and get colors in referenced cells
When you click in a cell with a formula, Excel will then put color
around the cells that are referenced.
Somehow I turned that feature off. Now I do not get colors in th
other cells. Where is that option to turn it back on???? I've looke
and looked but I just can't find that option.
Thanks for the help
albean's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2875
View this thread: http://www.excelforum.com/showthread.php?threadid=48436
...population pyramids using bar charts with a secondary axis
I have a problem that I had given up as unsolvable, but after recently
learning about secondary axes, I've made encouraging progress. However,
I'm stuck on the last step(s), and I'm hoping that someone will have
My organization has been producing reports that contain population
pyramids. In the past, all of their reports have been printed, so it
didn't matter that in order to get the desired look, they had to use
two charts slightly overlapping each other. However, we are getting to
the point where we would like our charts to be available online for
download....Getting Mailbox Sizes in 5.5
This is a multi-part message in MIME format.
Working on an Exchange 5.5 to 2K3 migration. Is there any easy way to =
get a list of mailboxes with their sizes from the Exchange 5.5 =
directory? I know I can use System Admin to see each server and then =
export the list, but is there a way to this, maybe with a script so I =
don't have to export the list from each server separately? Thanks.
Co...How do I get a scrollbar in a textfield
Is it possible to make a scrollbar in a textfield in publisher 2003. If the
answer is Yes, than my question is: How? If the answer is No, than can you
tell me if there is an alternative to show lots of text with use of an
> Is it possible to make a scrollbar in a textfield in publisher 2003. If the
> answer is Yes, than my question is: How? If the answer is No, than can you
> tell me if there is an alternative to show lots of text with use of an
Publisher is primarily designed for creating documents to be read on a
printed page. Obviousl...Getting rid of #DIV/0! #2
Does anybody know a quick way of getting rid of the error message
#DIV/0!. Like a way to change it into just 0 or something? Thanks
Here are some typical ways....
For values in A1 and B1
Different ways depending on your anticipated values....
Is that something you can work with?
> Does anybody know a quick way of getting rid of the error message
> #DIV/0!. Like a way to change it into just 0 or something? Than...Step Line Charts
Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point. What I want is a horizontal line until the next data point and then I want the line to go vertical.
You Will need some form of extra data to get excel to create a step
chart. Take a look at these methods.
> Does anyone know how I can create a step line chart without having to have 2 data points per x-axis point. What I want is a horizontal line until the next data point and then I want the line to go vert...Newbie question, can't get a handle on the handles <g> ... ?
How do we manipulate text that needs to flow to another box, i.e.,
when working in two columns and we need text to flow to a third, how
do we do this?
I'm sorry for such a simple question, but I've looked through the help
and on the web and I think it's because I don't know what it's called.
Anyhoo, pls advise!
Whilst attempting to develop brick-based storage technology, Ed reads a
message from Dylan56 <No@SpamAtAll.com>
> How do we manipulate text that needs to flow to another box, i.e.,
> when working in two columns and we need text to flow to a third,...How to get http response after post
My pseudo code and question are folowing:
DWORD dwBuffLen = sizeof(dwStatus);
CString strHttpName = "http://www.eee.com/login.asp";
char opt = "UserName=uuu&Password=ppp";
CString strHeaders = "Content-Type: application/x-www-form-urlencoded\r\n";
CInternetSession session("IE 5.0");
session.GetHttpConnection("www.dailygraphs.com",0,INTERNET_DEFAULT...can't get pc to hibernate
I have windows XP sp2, Sometimes in hibernation mode the shut down process
gets as far as "preparing to hibernate" and then the screen freezes. I then
have to use the on-off button to close the pc. Can anyone help in rectifying
this problem? I can copy the system information details to here if that will
Laurence, check out this Excellent Shutdown Troubleshooter
"laurence withau" <email@example.com> wrote in
message news:E97F9CA4-E8BA-41D3-81...how can I show repeating values in a chart?
I would like to show modes in the form of a pie chart but am not sure how.
For example the number 73 comes up 3 times in a column on my spreadsheet, how
can I show that compared to the number 50 which come up 2 times in the sheet?
Thanks for the help
You will need to compute those values using formula or a pivot table and
then chart the results.
> I would like to show modes in the form of a pie chart but am not sure how.
> For example the number 73 comes up 3 times in a column on my spreadsheet, how
> can I show that compared to the number 50 whi...more symbols in chart
I need to chart an experiment data for 28 monkeys. I
wanted to use a separate symbol for each monkey. I am
limited to black and white only, so I can't use multiple
I am experimenting on changing white, black for back
ground color, fore color, to make a distinct symbol for
each monkey. Does any body know how do we get more symbols
on the chart?
Thanks in advance for any help,
Jon Peltier has instructions for Custom series markers:
> I need to chart an experiment data for 28 ...Drop Down List for Chart
I have grouped my series into several groups. How do I display a drop down
list including the groups which will dynamically identify which series to
plot on the chart?
Group A = Series 1, Series 2, Series 3
Group B = Series 4, Series 5
Group C = Series 6
Drop down list includes values: "Group A", "Group B", "Group C"
When Group A is selected within the drop down, Series 1, 2 and 3 are plotted
on the chart.
Do you mean you have to plot data, and have the chart move week to week? if
so, easiest way is to use a hlookup/vlookup
"savior1&quo...Truncated "y" axis label in chart
:confused: Hi guys
I have a problem with Excel, the label on the �Y� axis appears
truncated even though I have resized the chart. Then, I looked the file
in another computer with the same version of excel than mine as well as
in another with a different version and in both look fine. Thus, I
erased and re-installed excel in my computer to no avail. I have also
re-sized the chart and used it both as object embedded and in separate
sheet, it doesn't fix the problem. Any suggestions to fix this problem?
-----------------------------------------------------------------------...How do I assign labels to scatter charts
I'm making an x-y scatter chart but can't assign labels to the individual
points. How do I do this?
Many thanks in advance for your help.
Here is an explanation of how to link a chart text element to a cell.
But if you have more than a couple of data labels to do you really need
to use code.
This free addin will do it for you.
> I'm making an x-y scatter chart but can't assign labels to the individual
> points. H...Pivot Table and adding a % column, that is not in original data
Hi, Is it possible to add a column for % calculations when the % column is
not in original data? To clarify, my original data is as follows:
Produt Sales Returns Date
A 5 June
B 6 June
A 1 July
A 1 September
B 1 November
When I run the pivot table, one of the columns I'm then looking to get is a
total % of returns over sales , but I cant see how to include in a Pivot
table. I can add it outside of the table, but that has problems ...Pivot Table #46
Hello, I have pivot table based on data that identifies an item as "late"
"late if not rec'd today" and "late if not shipped today". The totol lists
the correct number from each category for a location but when I double click
on that total I get a list of every entry for that location, not just the
late etc. What am I doing wrong?
When you double click on a total, does it generate a new worksheet? If
yes, it is listing out all the data, which the total field is made up
of. The other possibility is that you are unhiding a summary field.
xgirl...Pivot table total decimal places rounding
The totals in my pivot tables have too many decimal places.
I total -$1,025.31 and $1,023.87 and the result is
$1.43999999999994 in the total cell of the pivot table but
I need just $1.44 I have formatted the table as currency
and using 97.
Pivot tables can lose their formatting if the data is refreshed. Reapply
the formatting, and make sure that 'Preserve formatting' is checked
(under PivotTable>Table Options).
> The totals in my pivot tables have too many decimal places.
> I total -$1,025.31 and $1,023.87 and the result is
> $1.43999999999994 in the to...3D Pie Chart
Hello all-I have created a 3-D pie chart in Excel and would like some of the
pies to be thicker than others...raised higher, thicker, like have the same
foundation but the ones I am discussing during the presentation to raise
above the others not seperating from the pie. Does that make sense? I am
using Excell 2007 but also have access to 2003 and the newest version. If
anyone knows how to do this any help woould be so greatly apprecaited.
Excel is not designed to do that, maybe a simple alternative would be to
explode the segment of the pie you want to emphasize. To e...Scatter Charts #3
I am plotting a XY chart. I want that every point should be of different colour. Possibly I can define a range of 2 columns where column 1 contains the name for which the point is plotted and column 2 contains the colour for that point.
I have seen this being done in one chart but that person is no longer available for help
Please tell me how is it done
Hi Shilps -
Double click on the chart, and on the Options tab, check the Vary Colors
by Point box.
Now that you know where it's hidden, you'll become the resident expert!
Jon Peltier, Microsoft Excel...Fill Form And Get $5000 To Your Home.
Fill Form And Get $5000 To Your Home At http://ukcitygirls.co.cc
Due to high security risks,i have hidden the cheque link in an
image. in that website on left side below search box, click on image
and enter your name and address where you want to receive your
cheque. please don't tell to anyone.
...Formating, paragraph marks, boxes etc, how do I get rid of them?
One day I opened up excel and it had all these marks for formating in my
form. This also happened in word. How do I get rid of them?
In Word, paragraph marks can be turned on/off by clicking the paragraph
icon (looks like a capital P but with two, vertical strokes instead of one).
I just finished wandering through Excel 2000 looking for the same icon and
the only mention of the paragraph mark is related to object linking and
embedding. I've also done a lot of forms in Excel and don't remember ever
running into paragraph marks. Are you using OLE in the spreadsheet...Reprsent negative values in excel charts
Can someone help in how to reprsent the negative values in the chart and
which is the best chart to represent it?
What type of chart are you making? In a line, column, bar, XY, or area
chart, the negative values are merely plotted on the other side of an axis.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"uha" <firstname.lastname@example.org> wrote in message
> Can someone help in how to reprsent t...get execution tim
How can I get execution(run) time of my vc program?
> How can I get execution(run) time of my vc program?
A profiling tool is recommended. In my opinion, AQTime 4 is a good choice.
If you want to profile your program by hand or you've found your
profiling tool gives wrong results, you can use GetTickCount() or
QueryPerformanceCounter/QueryPerformanceFrequency. The latter is
recommended since it has higher precision.
...how do i subtract one date from another and get an age in years
i am trying to subtract a date of birth from today's date and get an age in
years. Can anyone help me?
Microsoft MVP - Excel
"ucastores" <email@example.com> wrote in message
>i am trying to subtract a date of birth from today's date and get an age in
> years. Can anyone help me?
"ucastores" &l...Money 2004: Error in Subtotals and Cash Flow Charts
On my Account List screen and in the charts on my Cash
Flow screen, the subtotals for my checking, credit card,
and investment accounts are shown as ridiculously large
numbers (i.e. $268,991,640,696,311.71). When I check
each account for beginning balances ($0) and all of the
transactions in each account, I can't find anything that
would be causing this. (The ending balances at the list
of transactions in each account is correctly listed.) My
currency is also correctly set to USD. Does anyone know
where this huge number might be coming from? Thanks.