Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Any Excel gurus here?
kirstiex
Posts: 175 Forumite
in Techie Stuff
I need to create a bar graph which overlaps so you can see the 'target' figure and the 'actual' figure slightly overlapping - I've managed to do this but I've also been asked for the 'actual' value to change to red font when it exceeds the budget value. Can this be done and does anyone know how - using Excel 2003.
0
Comments
-
Nice and easy in Google docs.
I'm sure it is possible, but I've only ever seen it done for positive and negative values.0 -
you need to look into if statements0
-
Do you want the cell text to change colour when its value is above a certain number (Format - Conditional Formatting) or change the value label on a chart when the number is exceeded (not sure how to do this, or if it's possible)?
Miles.0 -
Aren't you getting into macros/VBA territory here?
I've used if-conditionals in basic Excel formulae, but only ever to mess about with numbers tied to certain conditions, not to actually alter cell-formatting..
(stuff like "if Hours => 7.5 then Overtime = True")
I think you will have to look at macros here - Some of the management reports Iuse for work have cells which must be properly populated, so there are macros which scan them, and alter the cell-formatting such that they highlight in red if I have entered the data incorrectly;
So I know it can be done.
0 -
milesoneill wrote: »Do you want the cell text to change colour when its value is above a certain number (Format - Conditional Formatting) or change the value label on a chart when the number is exceeded (not sure how to do this, or if it's possible)?
Miles.
you need to clarify as above, I think both can be done but one is really easy the other more cpmplex0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.1K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards