This link has been bookmarked by 141 people . It was first bookmarked on 31 Jul 2006, by Steve Wilson.
-
09 Aug 12
-
27 Dec 10
-
24 Mar 08
-
13 Feb 08
-
28 Sep 07
-
01 Sep 07
-
13 Aug 07
-
10 Apr 07
-
09 Mar 07
-
28 Feb 07
-
27 Feb 07
Micah SittigNovel technique for lightweight data visualization in Excel. More tips in the comments.
-
22 Feb 07
-
21 Feb 07
-
We often are given a chunk of data in Excel that we need to explore. Of course, the first tool you should pull out of your toolbox in cases like this is the trusty PivotTable (it slices, it dices!). But at times we have to dig a little deeper into the toolbox and pull out the in-cell bar chart. Here’s what it looks like.
-
-
11 Feb 07
-
07 Feb 07
-
17 Jan 07
-
14 Jan 07
-
11 Jan 07
-
This works in Google Spreadsheets
-
-
02 Jan 07
-
30 Nov 06
-
23 Nov 06
-
27 Oct 06
-
24 Oct 06
-
22 Oct 06
-
07 Oct 06
-
02 Oct 06
-
27 Sep 06
-
20 Sep 06
T Hoffbauer# Henk Says:
July 31st, 2006 at 4:35 pm
Smooth trick, guys! Maybe the readers are interested in following.
You can extend this by conditional formatting, as you put, but another way is making bars growing to left or to right, depending when they a -
19 Sep 06
-
18 Sep 06
-
13 Sep 06
-
For in-cell bar charts, the trick is to repeat a single bar “|”. When formatted in 8 point Arial font, single bars look like bar graphs.
-
-
11 Sep 06
-
09 Sep 06
-
08 Sep 06
-
01 Sep 06
-
29 Aug 06
-
26 Aug 06
-
24 Aug 06
-
23 Aug 06
-
21 Aug 06
-
20 Aug 06
-
19 Aug 06
-
17 Aug 06
-
16 Aug 06
-
-
We often are given a chunk of data in Excel that we need to explore. Of course, the first tool you should pull out of your toolbox in cases like this is the trusty PivotTable (it slices, it dices!). But at times we have to dig a little deeper into the toolbox and pull out the in-cell bar chart. Here’s what it looks like.
-
-
15 Aug 06
-
Simon Keslake2007-05-19 18:24:43 +0100 from del.icio.us
---
2007-05-12 17:52:28 +0100 from del.icio.us
---
2007-05-12 17:22:26 +0100 from del.icio.us
---
2007-05-12 16:52:26 +0100 from del.icio.us
---
2007-05-12 16:22:34 +0100 from del.icio.us
---
2007-05-12 15:5 -
Alberto FernandezWe often are given a chunk of data in Excel that we need to explore. Of course, the first tool you should pull out of your toolbox in cases like this is the trusty PivotTable (it slices, it dices!). But at times we have to dig a little deeper into the too
-
-
This picture shows some Major League Baseball data. I’m graphing the number of walks each player has taken. The bar graphs are built using the Excel REPT function which lets you repeat text a certain number of times. ... For in-cell bar charts, the trick is to repeat a single bar “|”. When formatted in 8 point Arial font, single bars look like bar graphs.
-
This picture shows some Major League Baseball data. I’m graphing the number of walks each player has taken. The bar graphs are built using the Excel REPT function which lets you repeat text a certain number of times. ... For in-cell bar charts, the trick is to repeat a single bar “|â€. When formatted in 8 point Arial font, single bars look like bar graphs.
-
-
14 Aug 06
-
-
13 Aug 06
-
12 Aug 06
-
-
11 Aug 06
-
Gwen PattonThis is downright elegant.
business coding excel geek graphics hack howto interesting visualization utilities useful programming reference graph analysis data tips for:andrewski for:maggiel for:rarcke
-
Karsten Schmidtgreat idea for creating bargraphs (in the context of sparklines) in Excel
-
-
-
-
Lightweight data exploration in Excel
-
Page Comments
Would you like to comment?
Join Diigo for a free account, or sign in if you are already a member.