Charts, HTML, offset

[Snadyeka]

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

 

[Shane Devenshire]

Hi,

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

Cheers,
Shane Devenshire

 

[Jon Peltier]

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
_______

 

[Flowering Weeds]

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...-of-great-silverlight-charting-resources.aspx

It's a whole new world of charting!

 

[Flowering Weeds]

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!

 

[Jon Peltier]

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
_______

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...-of-great-silverlight-charting-resources.aspx

It's a whole new world of charting!

 

[Flowering Weeds]

Does this suffer from the same
licensing constraints as OWC?

Microsoft acquires Dundas’s data visualization
http://blogs.msdn.com/bimusings/arc...n-components-sql-2008-news-download-ctp3.aspx

Microsoft Chart Control vs. Dundas Chart Control
http://blogs.msdn.com/alexgor/archi...ft-chart-control-vs-dundas-chart-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/Forums/en-US/MSWinWebChart/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!

 

[Jon Peltier]

Microsoft acquires Dundas’s data visualization
http://blogs.msdn.com/bimusings/arc...n-components-sql-2008-news-download-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/archi...ft-chart-control-vs-dundas-chart-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/Forums/en-US/MSWinWebChart/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


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

 

[Flowering Weeds]

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.DataVisualization")

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

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

$series1 = New-Object
System.Windows.Forms.DataVisualization.Charting.Series
$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.ChartImageFormat]::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.