i have created a few charts that use =offset and comboxes to display
different data depending on which name is chosen.

a b a b a
1 day 1 day 2 day 3 day 4
2 John 12 16 15 17
3 Marie 11 13 15 16
4 Sandra 10 11 14 15
5 Alex 9 13 16 18

is there a way i can post the combo box with the chart in a html chart? i
am trying to show improvement one person at a time...

thanks

Hi,

It doesn't seem like you can publish a chart with interactive components, at
least not from inside of Excel.

Cheers,
Shane Devenshire

"Snadyeka" wrote:

i have created a few charts that use =offset and comboxes to display
different data depending on which name is chosen.

a b a b a
1 day 1 day 2 day 3 day 4
2 John 12 16 15 17
3 Marie 11 13 15 16
4 Sandra 10 11 14 15
5 Alex 9 13 16 18

is there a way i can post the combo box with the chart in a html chart? i
am trying to show improvement one person at a time...

thanks

I would think that Google's Chart API would be a good place to look for
internet-based charts. I haven't tried them out yet, only admired them from
afar, but what I've seen looks promising.

http://code.google.com/apis/chart/

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



"Shane Devenshire" wrote in
message ...
Hi,

It doesn't seem like you can publish a chart with interactive components,
at
least not from inside of Excel.

Cheers,
Shane Devenshire

"Snadyeka" wrote:

i have created a few charts that use =offset and comboxes to display
different data depending on which name is chosen.

a b a b a
1 day 1 day 2 day 3 day 4
2 John 12 16 15 17
3 Marie 11 13 15 16
4 Sandra 10 11 14 15
5 Alex 9 13 16 18

is there a way i can post the combo box with the chart in a html chart?
i
am trying to show improvement one person at a time...

thanks

I would think that Google's Chart API

FYI

If one knows Excel's VBA charting and / or
Office Web Components (OWC) charting via
scripting / C++ or C# then one can easily
use the newer Microsoft's .NET Chart Control.

Microsoft's newer charting (comes in .NET 4)
but out now (.NET 3.5) for Internet / server-side
ASP.NET and stand alone .NET apps and even at the
newer command line usage - via Windows PowerShell.

Samples Environment for Microsoft Chart Controls - Home
http://code.msdn.microsoft.com/mschart

ChartBuilder - (Silverlight version)
http://delay.members.winisp.net/ChartBuilder/

[A collection of great Silverlight Charting resources!]
http://blogs.msdn.com/delay/archive/...resources.aspx

It's a whole new world of charting!

Microsoft's newer charting (comes in .NET 4)
but out now (.NET 3.5) for Internet /
server-side ASP.NET and stand alone .NET
apps and even at the newer command line
usage - via Windows PowerShell.


Oh and it comes with a charting data binder
for Excel files too!

Does this suffer from the same licensing constraints as OWC? The licensing
and the overhead directed me away from OWC and anything later. Then Google
came along with a pretty easy alternative.

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


"Flowering Weeds" wrote in message
...

I would think that Google's Chart API

FYI

If one knows Excel's VBA charting and / or
Office Web Components (OWC) charting via
scripting / C++ or C# then one can easily
use the newer Microsoft's .NET Chart Control.

Microsoft's newer charting (comes in .NET 4)
but out now (.NET 3.5) for Internet / server-side
ASP.NET and stand alone .NET apps and even at the
newer command line usage - via Windows PowerShell.

Samples Environment for Microsoft Chart Controls - Home
http://code.msdn.microsoft.com/mschart

ChartBuilder - (Silverlight version)
http://delay.members.winisp.net/ChartBuilder/

[A collection of great Silverlight Charting resources!]
http://blogs.msdn.com/delay/archive/...resources.aspx

It's a whole new world of charting!

Does this suffer from the same
licensing constraints as OWC?

Microsoft acquires Dundas’s data visualization
http://blogs.msdn.com/bimusings/arch...load-ctp3.aspx

Microsoft Chart Control vs. Dundas Chart Control
http://blogs.msdn.com/alexgor/archiv...t-control.aspx

Microsoft Chart Control is .NET
(not OWC) released as a download
now for .NET Framework 3.5 but will be a
regular .NET class in 4.0 (next year?).

So it is the same as any .NET class.

Perhaps ask (or search) here

http://social.technet.microsoft.com/...bChart/threads

Also there is a Silverlight version for
Windows and the below is Mono (Linux):

Silverlight Toolkit, now MS-PL - Miguel de Icaza
http://tirania.org/blog/archive/2008/Nov-10.html

The licensing and the overhead
directed me away from OWC and
anything later.

Perhaps OWC licensing and etc. has changed.

Perhaps ask (or search) here.

microsoft.public.office.developer.web.components

Yep a whole new world of charting,
maps and gadgets!

"Flowering Weeds" wrote in message
...

Does this suffer from the same
licensing constraints as OWC?

Microsoft acquires Dundas’s data visualization
http://blogs.msdn.com/bimusings/arch...load-ctp3.aspx


Yeah, I read about that. I guess Excel 2007 charts aren't pretty enough.
This will sure improve them:
http://www.dundas.com/Dashboards/BestPractices.aspx


Microsoft Chart Control vs. Dundas Chart Control
http://blogs.msdn.com/alexgor/archiv...t-control.aspx

Microsoft Chart Control is .NET
(not OWC) released as a download
now for .NET Framework 3.5 but will be a
regular .NET class in 4.0 (next year?).

So it is the same as any .NET class.


The burden isn't licensing then.


Perhaps ask (or search) here

http://social.technet.microsoft.com/...bChart/threads

Also there is a Silverlight version for
Windows and the below is Mono (Linux):

Silverlight Toolkit, now MS-PL - Miguel de Icaza
http://tirania.org/blog/archive/2008/Nov-10.html

The licensing and the overhead
directed me away from OWC and
anything later.

Perhaps OWC licensing and etc. has changed.

Perhaps ask (or search) here.

microsoft.public.office.developer.web.components

Yep a whole new world of charting,
maps and gadgets!


Don't forget dials and gauges, donuts and pies. 3D effects, shadows,
transparent features. Cool.

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

Yep a whole new world of charting,

donuts and pies. 3D effects, shadows,
transparent features. Cool.


And one can do this at the command line
of Windows PowerShell (the automation
tool or the .NET cmd.exe clone) by typing
each line, one at a time or put the lines into
a file and call the file too!

[System.Reflection.Assembly]::LoadWithPartialName("System.Windows.Forms.DataVi sualization")

$chart1 = New-Object
System.Windows.Forms.DataVisualization.Charting.Ch art
$chart1.size = New-Object System.Drawing.Size(560, 310)

$chartArea1 = New-Object
System.Windows.Forms.DataVisualization.Charting.Ch artArea
$chartArea1.BackColor = "Silver"
$chart1.ChartAreas.Add($chartArea1)

$series1 = New-Object
System.Windows.Forms.DataVisualization.Charting.Se ries
$series1.Points.Add(23)
$series1.Points.Add(19)
$series1.Points.Add(11)
$chart1.Series.Add($series1)

# For Excel - create a data binder as a reader that
# reads the Excel file (a few more lines) then call.
# $chart1.DataBindTable($theReader, "Row to use for X")

# Show in a .NET form (etc.) or save.
$chartName = "$pwd\testChart.gif"
$chart1.SaveImage("$chartName",[System.Windows.Forms.DataVisualization.Charting.Ch artImageFormat]::Gif)

# Show the chart in the default image viewer.
invoke-item testChart.gif

Exit

For more Windows PowerShell (charting)

Perhaps ask (or search) here

microsoft.public.windows.powershell

Have fun with it all.