Charting in a cell
 

Does anybody have some information in creating a line chart that resides
within a cell that reflects the pattern of a row or column of numbers?
Someone at work referred to such a thing as a "spark line". Any VBA out there
to help with something like that ?
--
Dave_DD

Charting in a cell
 

Put some numbers in A1:A6 (1,5,8,10,15,12)
In B1 enter =REPT("-",A1)
Copy down to B6
Adjust column width of B as needed
Try other symbols in place of "-"
That's how we did it in Fortran in the 60's
OR get Excel 2007
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave_AD" wrote in message
...
Does anybody have some information in creating a line chart that resides
within a cell that reflects the pattern of a row or column of numbers?
Someone at work referred to such a thing as a "spark line". Any VBA out
there
to help with something like that ?
--
Dave_DD

Charting in a cell
 

On Sun, 11 Feb 2007, in microsoft.public.excel.charting,
Bernard Liengme said:

Put some numbers in A1:A6 (1,5,8,10,15,12)
In B1 enter =REPT("-",A1)
Copy down to B6
Adjust column width of B as needed
Try other symbols in place of "-"
That's how we did it in Fortran in the 60's
OR get Excel 2007

Bernard, that's not a sparkline. That's one number in a cell, expressed
as a column of a certain length. A sparkline is a series of numbers,
expressed as a tiny line or bar graph.

I have implemented sparklines in Excel, by simply creating a minimal
line or bar chart as an embedded frame, and dragging its corners into a
single cell while pressing the Alt key, to snap the frame to the cell
corners. The frame can then be moved, sized and copied with the cell,
although you'll have to change the data series it refers to by hand.

I find it's difficult to shrink the entire chart into one regular height
cell, so I double all the cell heights up and use 20 point text. If you
like, you can just snap it to two cells instead, but a true sparkline
should be the height of a single line of text.

Bissantz & Company GmbH offer a sparkline add-in for Excel called
SparkMaker:

http://www.bissantz.de/sparklines/sparkmaker.asp

This product takes a different approach: Bissantz have created a custom
font with bars, pies, dots and lines that, when used with their user
defined functions, creates a sparkline in the cell where the function is
entered. bonavistasystems.com also has a product called Microcharts, but
I haven't evaluated it.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Charting in a cell
 

Thanks for the suggestions. Seems to be a blog thread in Daily Dose of Excel
that gets me part of the way there through a VBA function,
--
Dave_DD


"Del Cotter" wrote:

On Sun, 11 Feb 2007, in microsoft.public.excel.charting,
Bernard Liengme said:

Put some numbers in A1:A6 (1,5,8,10,15,12)
In B1 enter =REPT("-",A1)
Copy down to B6
Adjust column width of B as needed
Try other symbols in place of "-"
That's how we did it in Fortran in the 60's
OR get Excel 2007

Bernard, that's not a sparkline. That's one number in a cell, expressed
as a column of a certain length. A sparkline is a series of numbers,
expressed as a tiny line or bar graph.

I have implemented sparklines in Excel, by simply creating a minimal
line or bar chart as an embedded frame, and dragging its corners into a
single cell while pressing the Alt key, to snap the frame to the cell
corners. The frame can then be moved, sized and copied with the cell,
although you'll have to change the data series it refers to by hand.

I find it's difficult to shrink the entire chart into one regular height
cell, so I double all the cell heights up and use 20 point text. If you
like, you can just snap it to two cells instead, but a true sparkline
should be the height of a single line of text.

Bissantz & Company GmbH offer a sparkline add-in for Excel called
SparkMaker:

http://www.bissantz.de/sparklines/sparkmaker.asp

This product takes a different approach: Bissantz have created a custom
font with bars, pies, dots and lines that, when used with their user
defined functions, creates a sparkline in the cell where the function is
entered. bonavistasystems.com also has a product called Microcharts, but
I haven't evaluated it.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Charting in a cell
 

Dave -

There are a few of these threads in Daily Dose. I had a little fun with it,
but haven't gotten anything really useful yet.

The third party sparkline utility I tried (Bissantz, but there are others)
led to problems with phantom VB projects, that is, projects remained in the
VB Editor after the parent workbook was closed. The only thing that removed
these phantom VB projects was removing the utility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Dave_AD" wrote in message
...
Thanks for the suggestions. Seems to be a blog thread in Daily Dose of
Excel
that gets me part of the way there through a VBA function,
--
Dave_DD


"Del Cotter" wrote:

On Sun, 11 Feb 2007, in microsoft.public.excel.charting,
Bernard Liengme said:

Put some numbers in A1:A6 (1,5,8,10,15,12)
In B1 enter =REPT("-",A1)
Copy down to B6
Adjust column width of B as needed
Try other symbols in place of "-"
That's how we did it in Fortran in the 60's
OR get Excel 2007

Bernard, that's not a sparkline. That's one number in a cell, expressed
as a column of a certain length. A sparkline is a series of numbers,
expressed as a tiny line or bar graph.

I have implemented sparklines in Excel, by simply creating a minimal
line or bar chart as an embedded frame, and dragging its corners into a
single cell while pressing the Alt key, to snap the frame to the cell
corners. The frame can then be moved, sized and copied with the cell,
although you'll have to change the data series it refers to by hand.

I find it's difficult to shrink the entire chart into one regular height
cell, so I double all the cell heights up and use 20 point text. If you
like, you can just snap it to two cells instead, but a true sparkline
should be the height of a single line of text.

Bissantz & Company GmbH offer a sparkline add-in for Excel called
SparkMaker:

http://www.bissantz.de/sparklines/sparkmaker.asp

This product takes a different approach: Bissantz have created a custom
font with bars, pies, dots and lines that, when used with their user
defined functions, creates a sparkline in the cell where the function is
entered. bonavistasystems.com also has a product called Microcharts, but
I haven't evaluated it.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

Charting in a cell
 

Dave

I have an alternative approach to sparklines with custom fonts.

This link shows my chart-in-cell and downloadable example. I also have an
example of how to size cell with VBA.

http://processtrends.com/pg_charts_chart_in_cell.htm

Kelly

http://processtrends.com


"Jon Peltier" wrote in message
...
Dave -

There are a few of these threads in Daily Dose. I had a little fun with
it, but haven't gotten anything really useful yet.

The third party sparkline utility I tried (Bissantz, but there are others)
led to problems with phantom VB projects, that is, projects remained in
the VB Editor after the parent workbook was closed. The only thing that
removed these phantom VB projects was removing the utility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Dave_AD" wrote in message
...
Thanks for the suggestions. Seems to be a blog thread in Daily Dose of
Excel
that gets me part of the way there through a VBA function,
--
Dave_DD


"Del Cotter" wrote:

On Sun, 11 Feb 2007, in microsoft.public.excel.charting,
Bernard Liengme said:

Put some numbers in A1:A6 (1,5,8,10,15,12)
In B1 enter =REPT("-",A1)
Copy down to B6
Adjust column width of B as needed
Try other symbols in place of "-"
That's how we did it in Fortran in the 60's
OR get Excel 2007

Bernard, that's not a sparkline. That's one number in a cell, expressed
as a column of a certain length. A sparkline is a series of numbers,
expressed as a tiny line or bar graph.

I have implemented sparklines in Excel, by simply creating a minimal
line or bar chart as an embedded frame, and dragging its corners into a
single cell while pressing the Alt key, to snap the frame to the cell
corners. The frame can then be moved, sized and copied with the cell,
although you'll have to change the data series it refers to by hand.

I find it's difficult to shrink the entire chart into one regular height
cell, so I double all the cell heights up and use 20 point text. If you
like, you can just snap it to two cells instead, but a true sparkline
should be the height of a single line of text.

Bissantz & Company GmbH offer a sparkline add-in for Excel called
SparkMaker:

http://www.bissantz.de/sparklines/sparkmaker.asp

This product takes a different approach: Bissantz have created a custom
font with bars, pies, dots and lines that, when used with their user
defined functions, creates a sparkline in the cell where the function is
entered. bonavistasystems.com also has a product called Microcharts, but
I haven't evaluated it.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3
instead.

Charting in a cell
 

Try the character "g"
as in
=REPT("g",A1/x)
where x is used to scale the lines

Then use the Webdings font for a bar...





On Feb 11, 10:32 pm, "Kelly O'Day" wrote:
Dave

I have an alternative approach to sparklines with custom fonts.

This link shows my chart-in-cell and downloadable example. I also have an
example of how to size cell with VBA.

http://processtrends.com/pg_charts_chart_in_cell.htm

Kelly

http://processtrends.com

"Jon Peltier" wrote in message

...

Dave -

There are a few of these threads in Daily Dose. I had a little fun with
it, but haven't gotten anything really useful yet.

The third party sparkline utility I tried (Bissantz, but there are others)
led to problems with phantom VB projects, that is, projects remained in
the VB Editor after the parent workbook was closed. The only thing that
removed these phantom VB projects was removing the utility.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

"Dave_AD" wrote in message
...
Thanks for the suggestions. Seems to be a blog thread in Daily Dose of
Excel
that gets me part of the way there through a VBA function,
--
Dave_DD

"Del Cotter" wrote:

On Sun, 11 Feb 2007, in microsoft.public.excel.charting,
Bernard Liengme said:

Put some numbers in A1:A6 (1,5,8,10,15,12)
In B1 enter =REPT("-",A1)
Copy down to B6
Adjust column width of B as needed
Try other symbols in place of "-"
That's how we did it in Fortran in the 60's
OR get Excel 2007

Bernard, that's not a sparkline. That's one number in a cell, expressed
as a column of a certain length. A sparkline is a series of numbers,
expressed as a tiny line or bar graph.

I have implemented sparklines in Excel, by simply creating a minimal
line or bar chart as an embedded frame, and dragging its corners into a
single cell while pressing the Alt key, to snap the frame to the cell
corners. The frame can then be moved, sized and copied with the cell,
although you'll have to change the data series it refers to by hand.

I find it's difficult to shrink the entire chart into one regular height
cell, so I double all the cell heights up and use 20 point text. If you
like, you can just snap it to two cells instead, but a true sparkline
should be the height of a single line of text.

Bissantz & Company GmbH offer a sparkline add-in for Excel called
SparkMaker:

http://www.bissantz.de/sparklines/sparkmaker.asp

This product takes a different approach: Bissantz have created a custom
font with bars, pies, dots and lines that, when used with their user
defined functions, creates a sparkline in the cell where the function is
entered. bonavistasystems.com also has a product called Microcharts, but
I haven't evaluated it.

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3
instead.

Charting in a cell
 

[Dave_AD] scrive in

Does anybody have some information in creating a line chart that
resides within a cell that reflects the pattern of a row or column of
numbers? Someone at work referred to such a thing as a "spark line".
Any VBA out there to help with something like that ?

http://www.prodomosua.eu/zips/sparklines.xls
(press F9)
.f

Charting in a cell
 

Fernando -

This is EXCELLENT!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"fernando cinquegrani" wrote in message
...
[Dave_AD] scrive in

Does anybody have some information in creating a line chart that
resides within a cell that reflects the pattern of a row or column of
numbers? Someone at work referred to such a thing as a "spark line".
Any VBA out there to help with something like that ?

http://www.prodomosua.eu/zips/sparklines.xls
(press F9)
.f

Charting in a cell
 

On Feb 15, 7:52 pm, "fernando cinquegrani"
wrote:
http://www.prodomosua.eu/zips/sparklines.xls

Nice! How do you get the sparklines pictures in the cells to update?
It can't be voodoo, but it sure looks like it. :)

Yours,
Garth.

Charting in a cell
 

Copy the range of cells under the chart
Hold Shift, select the Edit menu, select Paste Linked Picture
Move and resize the pasted picture over the desired cell.

The pasted linked picture updates automatically thanks to the link.

A quick note to Excel 2007 users. If you use Print or Print Preview of a
range containing linked pictures of a chart, the linked picture and the
original chart will be corrupted. This bug has been filed with Microsoft.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Garth T Kidd" wrote in message
oups.com...
On Feb 15, 7:52 pm, "fernando cinquegrani"
wrote:
http://www.prodomosua.eu/zips/sparklines.xls

Nice! How do you get the sparklines pictures in the cells to update?
It can't be voodoo, but it sure looks like it. :)

Yours,
Garth.