Brian Fantana
Well-known member
Could someone drop me a PM.
Ta.
Ta.
Got something to say or just want fewer pesky ads? Join us... 😊
[Help] Any Excel experts?
- Thread starter Brian Fantana
- Start date
Bazzza67
Member
I don't consider myself an Excel expert, but try this online resource, post your problem on the forum, (you have to set yourself up as a user) I'm pretty sure someone will be able to help you
https://www.mrexcel.com/
https://www.mrexcel.com/
MattBackHome
Well-known member
- Jul 7, 2003
- 11,957
Post the query on here. Excel questions are the only reason I keep coming back.
Brian Fantana
Well-known member
- Thread starter
- #5
I need to add a static average line to a pivot table chart, but I can't for the life of me work out how to do it. I know you can add various trendlines, but a normal average doesn't seem to be one of them.
I just put "add a static average line to a pivot table chart" into Google - loads of answers there.
I do understand that Google is not as clever as NSC, but in the unlikely event that you do not get an answer here, try that wannabe Google startup...
I do understand that Google is not as clever as NSC, but in the unlikely event that you do not get an answer here, try that wannabe Google startup...
Hampster Gull
Well-known member
- Dec 22, 2010
- 13,465
Will sort for $29
LowKarate
New member
$28 here.
happypig
Staring at the rude boys
50p (might not work though)
maffew
Well-known member
In what part of Excel do you require expertise? Would be cool to share it on here, always learn/teach something on an Excel thread. PM me if it's private information
Shropshire Seagull
Well-known member
NEVER EVER claim to be an EXPERT .....
an EX is a has-been and a
SPURT is a drip under pressure
an EX is a has-been and a
SPURT is a drip under pressure
Shropshire Seagull
Well-known member
But it isn't actually a 'spurt' is it? Its a purt. What's that then?
Well actually, it's "pert" not "purt", and that can describe the pointy bit of a cold tit [breast] .....
I spelled "pert" as "spurt" as that is what it sounds like when preceded with an "x"
Thanks for the clarification.
Back to the original issue of Excel help, as some of you may know [MENTION=6886]Bozza[/MENTION] owns and I contribute to a football finance website called the PriceOfFootball.com, where we look at how clubs have performed from a monetary perspective.
As a result there is now a very large spreadsheet containing the key financial data and trends for all the English and Scottish clubs, as well as divisional summaries etc. There is a separate worksheet for each club.
I have two questions
(1) Is it possible to quickly access an individual worksheet, as there are now a lot to trawl through when we are looking at a particular club?
(2) Is is possible to churn out a set of graphs/tables from the updated data when a club announces its results? At present I do it on a piecemeal basis, club by club, graph by graph, but I'm sure there must be a more efficient solution.
Many thanks
Regards
EP
As a result there is now a very large spreadsheet containing the key financial data and trends for all the English and Scottish clubs, as well as divisional summaries etc. There is a separate worksheet for each club.
I have two questions
(1) Is it possible to quickly access an individual worksheet, as there are now a lot to trawl through when we are looking at a particular club?
(2) Is is possible to churn out a set of graphs/tables from the updated data when a club announces its results? At present I do it on a piecemeal basis, club by club, graph by graph, but I'm sure there must be a more efficient solution.
Many thanks
Regards
EP
maffew
Well-known member
Probably the most efficient way to tackle Q1 is to have a reference table called say, menu, which is just a list of all the teams
Then use Hyperlink function to navigate to the worksheet of the same name eg =HYPERLINK("#"&A2&"!",A2)
Reason I would use the lookup list in column A us so you can use it as a variable in case it needed else where in the project
The above could equally be hardcoded for each team like so
=HYPERLINK(Arsenal!A1,"Arsenal")
You could also create a link on each teams sheet to take you back to menu
I think that is what you are after anyway
Question2, um where does the data come from and how is it updated/entered?
maffew
Well-known member
I would consider (even if its not needed immediately) 2 more columns , Country, Division for lookups, pivots etc
maffew
Well-known member
Where is the average being calculated from, is it a column in the pivot table?
Eg
Product,cost
Eggs,1
Milk,5
Cheese,2
So on this chart you would want a horizontal line at 2.66? (8/3) as avg cost (if the column is already an average you cant take an average of the average as the representative value)