SubscribeTop 10 Excel and Chart Templates
Sales Dashboards – 32 Examples, Vote for your option now [Visualization Challenge #2]
|
Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in… |
2010 Calendar – Excel Template [Downloads]
|
Here is a 2010 new year gift to all our readers – a free 2010 calendar excel file (a little secret: just change the year in “outline” sheet from 2010… |
Master Excel 2007 Ribbon with this Free Learning Guide
|
Over the last few years, there has been much debate about the merits and perils of Microsoft Ribbon UI in Excel 2007. Personally I think ribbon is a good way… |
Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]
|
Tracking issues and risks is where most of the project management time goes. Once the project planning and organizing activities are in good shape, most of the project management activities… |
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
|
Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data. In plain English, it means, you… |
Project Management: Show Milestones in a Timeline [Part 3 of 6]
|
Learn how to create a timeline chart in excel to display the progress of your project. Timelines are a good way to communicate about the project status to new team… |
Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
|
In today’s installment of project management using excel, we will learn about project tracking tool – to-do lists. Projects are nothing but a group of people getting together and achieving… |
Gantt Charts – Project Management Using Excel [Part 1 of 6]
|
This is a 6 part tutorial on project management using microsoft excel. These posts represent few of the things related to project management using excel that I have learned over… |
Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]
|
Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert. |
73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman
|
add to del.icio.us | add to Stumble How many times you created a chart in Microsoft excel and formatted it for minutes (and sometimes hours) to reduce the eye-sore? |
Project Management Dashboards (recommended product)
 |
|
Free Excel Templates & Downloads
A New Year Resolutions Template that Kicks Ass
|
Jennie, a sweet and ambitious lady set out to do 101 things in the next 1001 days. She took the inspiration from Day Zero Project. Not stopping there, she prepared… |
Highlighting Repeat Customers using Conditional Formatting [Part 2 of 2]
|
This is second part of 2 part series on conditionally formatting dates in excel. Highlighting Repeat Customers using Conditional FormattingIn yesterday’s post we have learned how to conditionally format dates using… |
Sales Dashboards – 32 Examples, Vote for your option now [Visualization Challenge #2]
|
Sales reports and dashboards are very common in any company. There are several ways in which you can visualize sales data to understand the trends and sales performance. So in… |
Track Your Mutual Fund Portfolio using Excel [India Only]
|
Excel is very good for keeping track of your investments. Due to its grid nature, you can easily create a table of all the mutual fund holdings and monitor the… |
How to Find Dates of Public Holidays using Excel
|
Lets celebrate these holidays in PHD Style. By learning few excel formulas that you can use to find out dates for some of the popular public holidays like – labor… |
Make a Quick Thermometer Chart to Compare Targets and Actuals
|
Comparing values is one of the reasons why we make charts. So today I am going to teach you a handy little trick to make a thermometer like chart to… |
2010 Calendar – Excel Template [Downloads]
|
Here is a 2010 new year gift to all our readers – a free 2010 calendar excel file (a little secret: just change the year in “outline” sheet from 2010… |
Christmas Gift List – Set your budget and track gifts using Excel
|
Steven, one of our readers from England sent me a Christmas gift tracker worksheet. I found it pretty cool, so made some minor changes to it and sharing it with… |
Personal Budget Spreadsheet [Downloads]
|
At PHD household, we believe in using money wisely. Both Mrs. PHD and I come from very modest backgrounds. Our upbringing has taught us value of money in the most… |
Top X chart – Show Top X values of a chart Interactively
|
Two charting principles we hear all the time are,
Today… |
Lets Pimp a Gauge Chart [Chart Porn Friday]
|
Egil, one of our alert readers from Norway sent this to me in e-mail, which I swear, I am not making up – A Fancy Gauge Chart. See the e-mail… |
Making Interaction Plots using Excel
|
Yesterday I read about interaction plots on junk charts where he points out the merits of an interaction plot. Interaction plots show interaction effects between 2 factors. For eg. you… |
Project Dashboard + Tweetboard = pure awesomeness!!!
|
Check out an implementation of project dashboard along with tweetboard by our reader Fernando. He says, it “turned out to be a great success”. I am so happy for him…. |
Prevent Duplicate Data Entry using Cell Validations
|
We all know that data validation is a very useful feature in Excel. You can use data validation to create a drop-down list in a cell and limit the values… |
Solve Sudoku Puzzles using Excel [because it is weekend]
|
Sanjay, my colleague is an avid programmer and excel enthusiast. In his spare time he wrote a small VBA macro to solve Sudoku. Sudoku is a very famous number based… |
Making a chart with dynamic range of values
|
We all know that to make a chart we must specify a range of values as input. But what if our range is dynamic and keeps on growing or shrinking. You… |
Baby Feeding Chart using Excel
|
While feeding the babies last night, I had this idea. Why not make an excel sheet where you can keep track of the baby’s feeding and sleeping activities on day… |
Project Management Dashboard / Project Status Report using Excel [Part 6 of 6]
|
Project management dashboards, project status reports help stakeholders, project sponsors and team-members can understand project status very quickly. In the last installment of project management using excel, learn how to… |
Recipe for a Donut Bar Chart
|
We all know that bar charts can be used to display values spread across various categories or times and pie charts / donut charts can be used to display percentage… |
Master Excel 2007 Ribbon with this Free Learning Guide
|
Over the last few years, there has been much debate about the merits and perils of Microsoft Ribbon UI in Excel 2007. Personally I think ribbon is a good way… |
Excel Check Boxes, Even Simpler Way
|
In how to get tickmarks in excel, Jon commented, That got me thinking, In excel, you can add… |
Issue Trackers & Risk Management using Excel [Project Management using Excel - Part 5 of 6]
|
Tracking issues and risks is where most of the project management time goes. Once the project planning and organizing activities are in good shape, most of the project management activities… |
Pareto Charts – How to do pareto analysis using Excel?
|
A Pareto chart or pareto graph displays the importance of various factors in decreasing order in columns along with cumulative importance in a line. Pareto charts are often used in… |
Dynamically Grouping Related Events [Excel Combo Charts with Pizzazz]
|
Yesterday we have posted how to use excel combo charts to group related time events. Today we will learn how to change the event grouping dynamically using form controls. This effect… |
Using Combo Charts to Group Related Time Events [Charting Goodness]
|
In his latest book, Now You See It, on pages 165 and 166 of the book, Stephen Few discusses how grouping related time intervals can facilitate analysis of data. As… |
50 Best Cities for Finding a Job [Incell Dashboard using Excel]
|
We all know that incell charts are a very cool way to explore and visualize data. Personally I like them so much that I have written several tutorials on it… |
Excel Pivot Tables Tutorial : What is a Pivot Table and How to Make one
|
Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your data. In plain English, it means, you… |
Waterfall Charts using Excel
|
Learn how to create waterfall charts in Excel in this tutorial. Our guest author, Aaron, explains how to create cool looking waterfall charts with connectors. Waterfall charts are great, especially… |
Excel Time Sheets and Resource Management [Project Management using Excel - Part 4 of 6]
|
Timesheets are like TPS reports of any project. Team members think of them as an annoying activity. For managers, timesheets are a vital component to understand how team is working… |
Build a Retirement Calculator using Excel (learn how to use Goal Seek as a bonus)
|
In this installment of spreadcheats, we will learn how to use goal seek feature of excel. We will build a retirement savings calculator using excel. We will learn to use… |
We cant Cure Cancer, But we can Cure this Medicare Chart [Chart Busters]
|
In this installment of Chartbusters, we take a look at a poorly constructed choropleth of medicare reimbursements in US and suggest cure for it. The post is from our Guest… |
Use burn down Charts in your project management reports [bonus post]
|
A burn down chart is a good way to understand the progress of a project. It is like a run chart that describes work left to do versus time. In… |
Generating invoice numbers using excel [reader questions]
|
Learn how to generate invoice numbers, tax codes etc. using Microsoft Excel. In this example we will take a real life example shared by Michelle and findout how we can… |
Make an Impressive Product Catalog [spreadsheets for small business]
|
It is the customer on the phone again, she wants to know what products we have. |
Project Management: Show Milestones in a Timeline [Part 3 of 6]
|
Learn how to create a timeline chart in excel to display the progress of your project. Timelines are a good way to communicate about the project status to new team… |
Team To Do Lists – Project Tracking Tools using Excel [Part 2 of 6]
|
In today’s installment of project management using excel, we will learn about project tracking tool – to-do lists. Projects are nothing but a group of people getting together and achieving… |
Gantt Charts – Project Management Using Excel [Part 1 of 6]
|
This is a 6 part tutorial on project management using microsoft excel. These posts represent few of the things related to project management using excel that I have learned over… |
Incell Dot Plots in Microsoft Excel
|
Dot plots are a very popular and effective charts. According to wikipedia “Dot plots are one of the simplest plots available, and are suitable for small to moderate sized data… |
Networkingdays() an improved version of networkdays formula
|
We all know that networkdays() an extremely powerful and simple excel formula can help you calculate no. of working days between 2 given dates. But there is one problem with it…. |
Venn Diagrams in Excel
|
This post is a testament that readers of this blog are way cooler and enterprising than I am. Justin, who I must say, has some really amazing excel skills, contacted… |
Tweetboard Implementations – Download and make your twitter style dashboard today
|
Check out two fabulous implementations of tweetboards in excel. Download the workbooks and play with them yourself. Thanks Fernando and Lee for sharing these workbooks with us…. |
Statistical Distributions in Excel [spreadcheats]
|
Excel has very powerful formulas and add-ins for performing almost any kind of statistical analysis. Today we will learn how you can make a statistical distribution of test scores using… |
Excel Tips Submitted by You [Part 2]
|
In today’s installment of “your week @ PHD” we will learn how to use array formulas to refine text search, a bunch of very useful keyboard shortcuts, and a very… |
Tweetboards – Alternative to traditional management dashboards
|
Here is a fun, simple and different alternative to traditional dashboards. Introducing…. |
Visualization Challenge – Budget vs. Actual Performance
|
Here is your chance to win a copy of The Visual Display of Quantitative Information by Edward Tufte, all you need to do is visualize budget vs. actual performance of… |
Excel Conditional Formatting Basics
|
Do you know What is excel conditional formatting? Learn the basics, few examples and see how you can use it in day to day work in this installment of… |
Us vs. Them – Compare Sales Performance using Charts & Form Controls
|
Today we will learn a little trick to compare 1 value with a set of values, For eg. our sales vs. competitor sales. We will learn how to create a… |
RSS Icon using Donut Charts – Because it is Weekend
|
RSS Icon using Donut Charts – Because it is… |
Japanese Candlestick Chart – Excel Tutorial
|
Japanese Candlestick Chart or Candlestick Chart as they are popularly known are one of the most commonly used stock charts.Today we will learn how to make a candlestick chart in… |
Market Segmentation Charts using Conditional Formatting
|
Trust Peltier to come up with solutions for even the most impossible looking charts. Today he shares a marimekko chart tutorial. I couldn’t sit still after seeing his post. So… |
Write Your Own Twitter Client using Microsoft Excel
|
Learn how you can write your own twitter client using Excel. All it takes is excel, internet connection and 5 minutes of spare… |
Visualizing Search Terms on Travel Sites – Excel Dashboard
|
Microsoft excel bubble chart based Visualization to understand how various travel sites compete search… |
Sales Funnel Charts in Excel – Tutorial
|
Sales funnel is a very common business chart. Here is a simple bar chart based trick you can use to generate a good funnel chart to be included in that… |
Excel Basics – What are Combination Charts and How to Make One?
|
A combination chart is when you combine two different charts to make one. A popular example for combination chart is a line & bar graph… |
Creating Excel Art from Images [spreadsheet fun]
|
Amit at Digital Inspiration features a lengthy way of creating beautiful excel cell art from an image. I guess we all can use a method that is little simpler and… |
2009 Calendar Template in Excel – Now with week starting on Monday
|
Stružák, one of the commenters on the 2009 Excel Calendar Template post asked me if I can rearrange the cells in the calendar so that the week could start on… |
Brick Charts in Excel – an Alternative to Gridlines
|
Grid lines provide great help in understanding values in a chart. Here is a handy trick you can use in the next bar chart to spice it up. Here is how… |
Free Excel Calendar Template for year 2009 (and all years up to 9999)
|
Free excel calendar template for year 2009 (well, it works for any year all the way up to 9999) Go ahead and download it, change the year number in the first… |
Advanced Data Validation Techniques in Excel [spreadcheats]
|
Data validation is a great way to keep your users informed about possible values in a cell and guide them to select something appropriate. As part of the spreadcheats series,… |
Extracting Unique, Duplicate and Missing Items using Formulas [spreadcheats]
|
Often I wish Microsoft had spent the effort and time on a data genie (and a set of powerful formulas) that can automate common data cleanup tasks like extracting duplicates,… |
Select & Show One Chart from Many
|
Yesterday I have learned this cool excel charting trick and I cant wait to share it with you all. |
Adding Box Plots to Show Data Distribution in Dashboards [Part 6 of 6]
|
This is a Guest Post by Robert on Visualization Techniques for Excel Dashboards. |
Sorting Text in Excel using Formulas
|
Sorting text is such a day to day activity that it always surprises me why Excel hasn’t provided a simple spreadsheet formula for doing it. Of course you can use… |
Sports Dashboards in Excel – A Tutorial
|
One of my favorite cricket player, the GOD – Sachin Tendulkar has become highest test run scorer. |
The New Poor – Internet Penetration Rates by Country
|
Yesterday is Blog Action day and tons of bloggers posted about single topic – poverty. It is a topic very close to my heart for various reasons. It is a… |
More than 3 Conditional Formats in Excel
|
One of the most popular posts on this blog is how to become excel conditional formatting rock star. Quite a few commenters there asked me if there is a way… |
Management Dashboards – Compare 2 Decision Parameters [Part 5 of 6]
|
This is a Guest Post by Robert on Visualization Techniques for Management Dashboards using Excel. |
Deal or No Deal – Download and Play the Popular TV Game Show in Excel
|
Ever since we moved to Seattle we have been watching TV game show – Deal or No Deal (for lack of better things to do in the hotel) The game… |
Simple Todo List application using Excel – Download and become productive
|
After seeing Andrew’s simple excel based check-list I got this idea of preparing a simple To-Do list application using excel. |
You are NOT spider man, so why do you use radar charts?
|
There are few charts in excel that are as revolting as a radar chart. The purpose of a radar chart is to compare m options across n parameters so that… |
Excel KPI Dashboards – Adding Micro Charts [Part 4 of 6]
|
This is 4th part of Creating Management Dashboards in Microsoft Excel 6 post series by Robert. |
Hack together a Gauge Chart in Excel without sweat
|
Gauges are a familiar metaphor, everyone can understand them, you can see them everywhere – near your stove, ac, car, gaming console, pc – you name it. So, when… |
Management Dashboards – Highlight Values Based on Percentile [Part 3 or 6]
|
Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert from Munich, Germany. |
Creating KPI Dashboards in Microsoft Excel [Part 2 or 6] – Adding One Click Sort
|
Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert from Munich, Germany. |
Creating KPI Dashboards in Microsoft Excel [Part 1 of 6]
|
Creating KPI Dashboards in Microsoft Excel is a series of 6 posts by Robert. |
It is show time baby! – better designer clocks to display time in your spreadsheets
|
My polar clock using donut charts in excel started a conversation and readers have been awesome enough to download the excel and create their own clocks to show time. Even… |
Polar clock using donut chart [Excel Visualization fun]
|
Smashing Magazine is one of daily hangouts for new design ideas, inspiration and ogle fun. When they featured Pixel Breaker’s Polar clock last Friday on Top 10 creative ways to… |
Plot your data around the clock [Excel charting idea]
|
If your reports include hourly distribution of data like, Customer footfalls in your store here is an interesting charting idea… |
The Olympic Medals by Country Chart – Improved now
|
My Olympic medals by country year visualization in excel is received well by readers. I got few interesting emails on it. |
Doing the NY times Olympic medals by country year visualization in excel
|
When I saw the Olympic medals won by each country by year infographic on nytimes my jaw almost dropped, go ahead see it and come back, I am sure you… |
Excel Bullet Graphs
|
Bullet graphs provide an effective way to dashboard target vs. actual performance data, the bread and butter of corporate analytics. |
Bingo / Housie Ticket Generator in Excel
|
I am fascinated by board games. They provide immense fun, anyone can enjoy them, they are unpredictable and best of all they are great value for money. That is why… |
Incell Bar charts – Revisited
|
I can never get tired of in-cell charts, whenever I get sometime, I try to experiment something on them. Here is an idea to design true incell column charts without… |
Partition Charts in Excel – alternative to pie charts [visualization hack]
|
Next time you had to create a pie chart, consider building a partition chart as these charts can reveal trend information along with how much each pie is contributing. What… |
Hot Thermometer Charts in Excel – here is a cool way to do them
|
Let us learn a simple charting hack to create a thermo-meter chart in excel. This type of charts can be effective in communicating one data point, they can make excellent… |
Learn Excel IF Formula – 5 Tricks you Didnt know
|
Excel has various functions, including functions to calculate inverse cosine of a given value, to multiply 2 matrices, to estimate the internal rate of return. But, most of us(well, just… |
How to add a range of cells in excel – concat()
|
Excel concatenate() is seriously crippled, it can add 2 or more strings together, as long as they are supplied as separate parameters. This means, when you have a range of… |
Gantt in 60 seconds – churn out an excel project plan in no time
|
One of the most frequent tasks for any manager is “planning”, be it putting together a hiring schedule or designing a jumbo jet, it all starts with a simple project… |
Creating in-cell bar charts / histograms in excel
|
Ever since writing the create in-cell pie charts in excel, I have been itching to find a simple enough method to do incell bar graphs. An in-cell bar would probably… |
Create in-cell pie charts in Excel
|
Here is a ridiculously easy trick to do nice incell pie charts in excel, what more, they will make you look like a charting wizard. Download free pie chart font… |
Create Cool Tag Clouds in Excel using VBA
|
I was toying with the idea of creating a tag cloud in excel – as a form of new visualization, this could be useful when you have medium amounts of… |
Mutual Fund Portfolio Tracker using MS Excel
|
Would you like to spend next 5 minutes learning how to create an excel sheet to track your mutual fund portfolio? |
73 Free Designer Quality Excel Chart Templates – Grab now and become a charting superman
|
add to del.icio.us | add to Stumble How many times you created a chart in Microsoft excel and formatted it for minutes (and sometimes hours) to reduce the eye-sore? |
Conditional Formatting in Excel – 5 Tips to make you a Rockstar
|
Excel conditional formatting is a hidden and powerful gem that when used well, can change the outlook of your project report / sales budget / project plan or analytical outputs… |
How to: sharing trip expenses using excel
|
Yesterday we were calculating our Washington trip expenses and it occurred to me that if there is an excel template where I could enter the trip expenses and who paid… |
The Art of Excel Charting
|
Yesterday while going through my feeds, I have landed on this post about the demographics and use-figures of various social networking (2.0) tools, et al (by businessweek) on think:lab blog…. |
Start Early
|
Financial freedom, or not having to work for someone is the ultimate dream for anyone wearing an access card and refreshing his/her mailbox every five minutes. Just incase you are… |
Find out whether you need a house or not in 60 seconds
|
Most of my classmates and friends have started purchasing houses. This coupled with the fact that I am in coveted DINK (double income no kids) group now have prompted me… |
Trackbacks & Pingbacks
- Pingback by Excel Links of the Week - All Downloads at One Place Edition | Pointy Haired Dilbert - Chandoo.org on November 10, 2008 @ 7:58 pm
- Pingback by PHD Welcomes Readers from Lifehacker | Pointy Haired Dilbert - Chandoo.org on November 12, 2008 @ 8:44 pm
- Pingback by Weekly Links - Even More Downloads Edition | Pointy Haired Dilbert - Chandoo.org on February 12, 2009 @ 12:11 am
- Pingback by How to use Excel Chart Templates | Charts & Graphs | Pointy Haired Dilbert - Chandoo.org on March 10, 2009 @ 11:56 am
- Pingback by How to use Excel Chart Templates | Charts & Graphs | Pointy Haired Dilbert - Chandoo.org on March 10, 2009 @ 11:56 am
- Pingback by Free Excel Chart Templates - Make your Bar, Pie Charts Beautiful | Charts & Graphs | Pointy Haired Dilbert - Chandoo.org on May 14, 2009 @ 4:13 am
- Pingback by Pointy Haired Dilbert becomes Excel @ Work | blogging | Excel @ Work: Charting & Excel Tips - Chandoo.org on May 18, 2009 @ 10:01 am
- Pingback by Pointy Haired Dilbert: amazing MS Excel blog offers free downloadable templates | freewaregenius.com on July 23, 2009 @ 2:35 am
- Pingback by Awesome Free Excel Templates | Olinda Services on July 24, 2009 @ 1:03 pm
- Pingback by 5 Things you probably dont know about this site | Pointy Haired Dilbert: Charting & Excel Tips - Chandoo.org on September 28, 2009 @ 1:07 pm
- Pingback by Free download various Excel Templates on October 3, 2009 @ 9:11 pm
- Pingback by ?????Excel?? | ??? on October 8, 2009 @ 10:01 pm
Comments
RSS feed for comments on this post. TrackBack URI
At Pointy Haired Dilbert, I have one goal, "to make you awesome in excel and charting". PHD is started in 2007 and today has 300+ articles and tutorials on using excel, making better charts. 
test comment…. just to see if page level comments work
Hi Chandoo,
I am trying to locate one of your posts re how to prepare a market share chart. (preferably Bars). Can you please help me locate this.
Regards
Waseem
@Waseem: You can find the entire discussion related to mkt share displays here: http://chandoo.org/wp/2008/11/14/excel-charting-alternatives-market-share-data/
We haven’t posted any tutorials or download books for this.
in excel i have sales quandity and sales value, if i use pivot chart the sales qty& value is coming parallely. But i need the value should come below the total quandity
as follows
product Sales qty
paste 50
Brush 100
Blade 500
total Qty 650
Value 1900
pl kindly guide me
Hi Chandoo,
This is first time, I am visiting you blog site and very impressive. I have been working with excel for last 7 years…still a first time learner. Anyways, I am currently using Office 2007, and it is good with some features compared to 2003, and I also remember you mentioned about the Classic menu, and I found a link from where you can download to get a classic Menu.
http://www.download.com/Classic-Menu-for-Excel-2007/3000-18483_4-10637173.html
Hope this helps.
@Deepak: Welcome and thanks for the nice words you say. and thank you so much for sharing the classic menu link. While I enjoy the excel 2003 menu structure and familiarity, I am trying very hard (and enjoying it equally) to learn the ribbon UI and where everything went in 2007. So far the experience is good
Keep visiting the blog and I am sure you will like many more ideas and content featured here.
“Executive Dashboards – Excel Training” – when downloaded is not opening. Please help.
@Raj Kiran : I dont see any issues while downloading the file. Can you try again , may be from a different net connection and let us know.
Hello,
I want to know how to use the vlook up in the excel sheet
Hi Chandoo,
Now am able to open the Executive Dashboard.
Thank you.
want to make equity stock portfolio tracker in excel like mutual fund portfolio tracker.
please help me
@Jignesh: The ideas are similar to the ones presented in mf portfolio tracker tool. Often the challenge is to get the information in a tabular format.
hi Chandoo,
your work is impressive! im just wondering if you could create similar chart in access for the report? or any advice on how to use excel charts in access?
thanks
Love your site! It has helped me a lot!
I have been using your MF Portfolio Tracker for the last one month and am extremely surprised for your SUPER invention. Thanks.
1. Is it possible for you to incorporate an additional coloumn in “Latest NAV Data” Sheet about Launch Dates for the respective schemes ?
2. Do you have similar Portfolio Tracker for Equity Shares liseted on NSE and BSE ? If yes please mail me its link.
Good Morning Chandoo,
Thanks for every tips and tricks that are on this site;
I have been working in excel for past 3 years and was struggling to make good looking Dashboard which finally I found in here.
It would be nice enough if you could provide more examples on dashboards………
Good Day……
@Stan… Thank you..
I am sure there are ways to create similar charts in Access (atleast by calling the excel application and creating the charts). But I am not really an access expert. But I think you can use VBA to do this…
@PESFan… you are welcome
@Sunita:
(1) Launch dates.. hmm, I dont think the URL http://www.amfiindia.com/spages/NAV1.txt provides launch dates. But since these dates are static, you can have them in another table (or named range) and then refer to them in your vlookup. Do you know any good data source for getting the launch dates?
(2) I have built one using google spreadsheets (you can find it here: http://chandoo.org/wp/2008/09/12/track-stock-mf-portfolio-google-docs/ ) May be you can extend the ideas and use it in Excel (you can get stock quotes by polling yahoo finance or google finance apis..)
@Durga: Thanks for your comments and Welcome to PHD. We have quite a good number of dashboard related resources here: http://chandoo.org/wp/management-dashboards-excel/
I write about dashboards or visualizations every now and then. Subscribe to the blog and keep watching…
Hi Chandoo,
Great Website. Am looking for an excel template to store information related to Helpdesk, where information can be stored and can be retrieved at a click of a button when required or asked by any of the customer. A knowledge database kinda stuff but excl based.
Thanks
Stephen
Hello CEO,
I viewed excel-sorting-text-alphabetically-wth-formulas worksheet, and it was very very nice. You are a very clever guy. Keep up the good work.
Jason
Thank you so much Chandoo. Your website is so impressive. It has really helped me in various projects I have. I wish you all the best and I hope your website becomes a world-wide success.
Hi Chandoo
Replicon, a timesheet software provider, has a set of free excel templates for timesheet at http://www.replicon.com/excel-timesheet.aspx. I thought you may find it useful and list it for visitors who are looking for excel timesheets.
Cheers
Revv
I have started using MF Portfolio Tracker which is good and useful.
In Latest NAV Data, I have edited the file as “NAV0″ which updates NAVs for Open Ended as well as Close Ended Schemes
The Problem is :
1. In the “Portfolio Sheet” if I choose any Scheme which pertains to LESS THAN CELL No. 6518 from the “Latest NAV Data” Sheet , it works fine and the NOW NAV displays the correct Value.
If we choose a Scheme which belongs to the CELL GREATER than CELL 6518 from the “Latest NAV DATA”, then the NOW NAV in the “Portfolio Sheet” shows the words “not found”.
Please help how to get Values of Now NAV if the Scheme is from the Cell Greater than 6518.
Hi Chandoo.
The website and contents are very much useful.
I highly appreciate your efforts for the work done.
Please keep this going on forever.
Thanks
how to get the updated NAV in MF Portfolio Tracker. its not getting update automatically while opening the excel sheet.
Your candlestick template helped me visualize a way in which to test and then combine my knowledge of Excel Candlestick formulas, with a testing layout for candlestick efficiency. I talk about that here:
http://bxcapricorn.blogspot.com/2009/10/one-more-jab-at-candlesticks.html
Just wanted you to know that one idea leads to another. Thanks.
Excellent templates.
Who so ever has prepared it , Thanks a lot!
if you are interested in templates for some really tricky Excel-Charts without any programming, have a look at
http://www.hichert.com/de/consulting/schaubilder/65
and
http://www.hichert.com/de/software/exceldiagramme/55
Is there an easy [cheap] way to hide several rows based on a value. I have a contact list that is 6 rows by 9 cols for each contact. For some contact lists there are 3 contacts and for some there can be 20. I need to hide the rows that are not populated in the report or be able to expand the preformatted rows based on a value that determines the number of contacts.
Try Grouping
Select Rows or Columns and Alt Shift Right Arrow
That will leave a small + on the side / top which allows you to hide / unhide the rows/cols
To ungroup select Rows/Cols and Alt Shift Left Arrow
i am looking after as a public infromation officer under RTI act in a govt organization.as per the act all of the application recieved must be supplied with required information within 30 days.i wish to register every application in MS EXCEL and would like to appply such a formula which can notify me as the 30 th day is close to come.
for me the problem is how to write a formula which can count the perrticular days for each month as jan is 31,april is 30 like this.
pls think over and give me yr valuable suggestions
Hi Chandoo,
Can I download these excel templates for use on a mac?
apb
Atul,
You can claculate the number of days in each month using the following formula assuming the date is in cell B2:
=DAY(DATE(YEAR(B2),MONTH(B2)+1,1)-1)
Essentially, this just goes to first day of the next month then subtracts a day.
@Russ
You can combine the “first day minus one” part of your formula directly in the Date function call like this…
=DAY(DATE(YEAR(B2),MONTH(B2)+1,0))
Basically, the zeroeth day of a month is the last day of the previous month.
@Antonio.. I am not sure if the VBA based templates work on mac. Rest of them should work just fine. Let me know if you face any problem.
can anybody tell me that can excel be used as a database with php ? actually i am developing a site and i have a excel file which contain the data and this data i want to have on the web page , anybody please ,
David Brown
@David… Interesting question. There are some frameworks based on PHP (or even java, ASP) that can read / write to excel files. You can use one of these to process the excel data. But if all you need is to read the data, you can as well write a VBA macro that will convert excel to access or mysql table and then read that in PHP. Whenever the file changes, just re-run your macro.
All the best
Hello:
I am looking for a soft copy of 7. Quarter-wise Snapshot of Budget Performance which is a part of “Budget vs. Actual Charts – 14 Charting Ideas You can Use”. Kindly help me in locating the excel file of this so that I can understand the concept in entirety.
Thank you in advance.
@Kshatrapati… These are entries for a contest, I dont have source files. You can try commenting on the post or asking the maker (if URL is available). But a better approach would be to make something like that on your own.