Chart Type Info

Hello everybody,
Posting for the first time. I am using Vb Scripting to generate some
charts based of data from SQLServer. I was able to get all the charts
displayed properly. However, I have a question with regards to way how the
lines in the charts are being displayed.

I will try to explain my problem using excel terminology. Lets say for the
grid of values shown below,

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
12 34 08 45 19 23 33 17 53 23 11 09

It plots the graph normally. But if the values are like this:

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
12 34 08 45 23 33 17 23 11 09

The places where the values are not there, the chart is defaulting to zero,
which I don't want. I want the line chart to end at April and then continue
from June and end at August, then continue from October.

I tried several different chart type values, but didn't get the
functionality I was looking for. Does anyone have any ideas to resolve this
issue?

Thanks,
Prasad Yarlagadda

Roland
Thu Aug 18 00:25:42 CDT 2005

"yarlagadda" wrote in message
news:CB1D2D9E-050A-4E0F-B80F-1D678E256FE7@microsoft.com...
: Posting for the first time. I am using Vb Scripting to generate some
: charts based of data from SQLServer. I was able to get all the charts
: displayed properly. However, I have a question with regards to way how the
: lines in the charts are being displayed.
:
: I will try to explain my problem using excel terminology. Lets say for the
: grid of values shown below,
:
: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
: 12 34 08 45 19 23 33 17 53 23 11 09
:
: It plots the graph normally. But if the values are like this:
:
: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
: 12 34 08 45 23 33 17 23 11 09
:
: The places where the values are not there, the chart is defaulting to
zero,
: which I don't want. I want the line chart to end at April and then
continue
: from June and end at August, then continue from October.
:
: I tried several different chart type values, but didn't get the
: functionality I was looking for. Does anyone have any ideas to resolve
this
: issue?

I've never seen a chart work that way but if it's at zero, isn't that the
same as ending?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

yarlagadda
Mon Aug 22 16:20:07 CDT 2005

>
> I've never seen a chart work that way but if it's at zero, isn't that the
> same as ending?
>
> --
> Roland Hall

If there is no value in a cell, then that doesn't mean its zero. Using the
values that I have given, I am looking for the option like this:

-- Create a line chart in Excel (you can use the data I gave before)
-- Then click on the graph
-- Then select Tools -> Options
-- Go to the 'Chart" tab in the options.
-- Under 'Active Chart', there are choices for 'Plot Empty cells as'
-- I want to be able to plot for the option to 'Not Plotted (Leave gaps)'

Thanks for your help,
Prasad Yarlagadda

Roland
Tue Aug 23 18:54:28 CDT 2005

"yarlagadda" wrote in message
news:9D013001-629D-496B-B620-C522E30E689D@microsoft.com...
: If there is no value in a cell, then that doesn't mean its zero. Using the
: values that I have given, I am looking for the option like this:
: -- Create a line chart in Excel (you can use the data I gave before)
: -- Then click on the graph
: -- Then select Tools -> Options
: -- Go to the 'Chart" tab in the options.
: -- Under 'Active Chart', there are choices for 'Plot Empty cells as'
: -- I want to be able to plot for the option to 'Not Plotted (Leave gaps)'

I just did it and it does what you want but it depends on the chart subtype.
What version are you using?

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

Roland
Tue Aug 23 18:58:41 CDT 2005

"Roland Hall" wrote in message
news:%23HisB4DqFHA.2364@tk2msftngp13.phx.gbl...
: "yarlagadda" wrote in message
: news:9D013001-629D-496B-B620-C522E30E689D@microsoft.com...
:: If there is no value in a cell, then that doesn't mean its zero. Using
the
:: values that I have given, I am looking for the option like this:
:: -- Create a line chart in Excel (you can use the data I gave before)
:: -- Then click on the graph
:: -- Then select Tools -> Options
:: -- Go to the 'Chart" tab in the options.
:: -- Under 'Active Chart', there are choices for 'Plot Empty cells as'
:: -- I want to be able to plot for the option to 'Not Plotted (Leave gaps)'
:
: I just did it and it does what you want but it depends on the chart
subtype.
: What version are you using?

Here's a 3-d view of the chart.
http://kiddanger.com/lab/book1.mht

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

yarlagadda
Thu Aug 25 09:51:04 CDT 2005

Roland,
Thanks for verufying that. I am able to do this in Excel (My version is
Office Excel 2003 (11.6355.6360)), but when I am using vbsript to generate
chart from data, I am not able to get it. I tried several different chart
types, but to no avail. I tried the chart types that are available here,
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/owcvba10/html/ocproDataSource.asp

In that link, click on "Type property as it applies to the ChChart and
ChSeries objects." and then click on the "ChartChartTypeEnum." I tried the
types listed there. But for some reason, wherever there is no value, these
chart types are defaulting to 0. Can you think of any other chart types that
I missed that might be useful for this scenario?

Thanks,
Prasad Yarlagadda

"Roland Hall" wrote:

> "Roland Hall" wrote in message
> news:%23HisB4DqFHA.2364@tk2msftngp13.phx.gbl...
> : "yarlagadda" wrote in message
> : news:9D013001-629D-496B-B620-C522E30E689D@microsoft.com...
> :: If there is no value in a cell, then that doesn't mean its zero. Using
> the
> :: values that I have given, I am looking for the option like this:
> :: -- Create a line chart in Excel (you can use the data I gave before)
> :: -- Then click on the graph
> :: -- Then select Tools -> Options
> :: -- Go to the 'Chart" tab in the options.
> :: -- Under 'Active Chart', there are choices for 'Plot Empty cells as'
> :: -- I want to be able to plot for the option to 'Not Plotted (Leave gaps)'
> :
> : I just did it and it does what you want but it depends on the chart
> subtype.
> : What version are you using?
>
> Here's a 3-d view of the chart.
> http://kiddanger.com/lab/book1.mht
>
> --
> Roland Hall
> /* This information is distributed in the hope that it will be useful, but
> without any warranty; without even the implied warranty of merchantability
> or fitness for a particular purpose. */
> Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
> WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
> MSDN Library - http://msdn.microsoft.com/library/default.asp
>
>
>

Roland
Thu Aug 25 13:48:22 CDT 2005

"yarlagadda" wrote in message
news:5B73AF57-AC39-4726-8CA8-62807FA6E9CA@microsoft.com...
: Roland,
: Thanks for verufying that. I am able to do this in Excel (My version is
: Office Excel 2003 (11.6355.6360)), but when I am using vbsript to generate
: chart from data, I am not able to get it. I tried several different chart
: types, but to no avail. I tried the chart types that are available here,
:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/owcvba10/html/ocproDataSource.asp
:
: In that link, click on "Type property as it applies to the ChChart and
: ChSeries objects." and then click on the "ChartChartTypeEnum." I tried the
: types listed there. But for some reason, wherever there is no value, these
: chart types are defaulting to 0. Can you think of any other chart types
that
: I missed that might be useful for this scenario?

Showing some code would make it easier no this end. I looked in Excel and
some types show the gaps and some do not. I'm assuming with this list I'm
using chChartTypeLineStacked3D.

ChartChartTypeEnum can be one of these ChartChartTypeEnum constants.
chChartTypeArea
chChartTypeArea3D
chChartTypeAreaOverlapped3D
chChartTypeAreaStacked
chChartTypeAreaStacked100
chChartTypeAreaStacked1003D
chChartTypeAreaStacked3D
chChartTypeBar3D
chChartTypeBarClustered
chChartTypeBarClustered3D
chChartTypeBarStacked
chChartTypeBarStacked100
chChartTypeBarStacked1003D
chChartTypeBarStacked3D
chChartTypeBubble
chChartTypeBubbleLine
chChartTypeColumn3D
chChartTypeColumnClustered
chChartTypeColumnClustered3D
chChartTypeColumnStacked
chChartTypeColumnStacked100
chChartTypeColumnStacked1003D
chChartTypeColumnStacked3D
chChartTypeCombo
chChartTypeCombo3D
chChartTypeDoughnut
chChartTypeDoughnutExploded
chChartTypeLine
chChartTypeLine3D
chChartTypeLineMarkers
chChartTypeLineOverlapped3D
chChartTypeLineStacked
chChartTypeLineStacked100
chChartTypeLineStacked1003D
chChartTypeLineStacked100Markers
chChartTypeLineStacked3D
chChartTypeLineStackedMarkers
chChartTypePie
chChartTypePie3D
chChartTypePieExploded
chChartTypePieExploded3D
chChartTypePieStacked
chChartTypePolarLine
chChartTypePolarLineMarkers
chChartTypePolarMarkers
chChartTypePolarSmoothLine
chChartTypePolarSmoothLineMarkers
chChartTypeRadarLine
chChartTypeRadarLineFilled
chChartTypeRadarLineMarkers
chChartTypeRadarSmoothLine
chChartTypeRadarSmoothLineMarkers
chChartTypeScatterLine
chChartTypeScatterLineFilled
chChartTypeScatterLineMarkers
chChartTypeScatterMarkers
chChartTypeScatterSmoothLine
chChartTypeScatterSmoothLineMarkers
chChartTypeSmoothLine
chChartTypeSmoothLineMarkers
chChartTypeSmoothLineStacked
chChartTypeSmoothLineStacked100
chChartTypeSmoothLineStacked100Markers
chChartTypeSmoothLineStackedMarkers
chChartTypeStockHLC
chChartTypeStockOHLC


--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

yarlagadda
Thu Sep 08 11:55:02 CDT 2005



"Roland Hall" wrote:

> "yarlagadda" wrote in message
> news:5B73AF57-AC39-4726-8CA8-62807FA6E9CA@microsoft.com...
> : Roland,
> : Thanks for verufying that. I am able to do this in Excel (My version is
> : Office Excel 2003 (11.6355.6360)), but when I am using vbsript to generate
> : chart from data, I am not able to get it. I tried several different chart
> : types, but to no avail. I tried the chart types that are available here,
> :
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/owcvba10/html/ocproDataSource.asp
> :
> : In that link, click on "Type property as it applies to the ChChart and
> : ChSeries objects." and then click on the "ChartChartTypeEnum." I tried the
> : types listed there. But for some reason, wherever there is no value, these
> : chart types are defaulting to 0. Can you think of any other chart types
> that
> : I missed that might be useful for this scenario?
>
> Showing some code would make it easier no this end. I looked in Excel and
> some types show the gaps and some do not. I'm assuming with this list I'm
> using chChartTypeLineStacked3D.
>
> ChartChartTypeEnum can be one of these ChartChartTypeEnum constants.


I was able to fix this issue using an article in Microsoft KB. Article ID :
326103

Just wanted to update in case anyone else might run into this same issue.
One issue I had with this article was, it was not recognising NULL value when
passed in the string. So, whenever I got null values, I made it zero and in
the code I asked it no to draw a line if its zero.

Sorry for delay in replying. Thanks for all the help.

Prasad Yarlagadda

Roland
Thu Sep 08 15:28:12 CDT 2005

"yarlagadda" wrote in message
news:4635B82E-549C-43B8-A77C-48DCF392F5A3@microsoft.com...
:
:
: "Roland Hall" wrote:
:
: > "yarlagadda" wrote in message
: > news:5B73AF57-AC39-4726-8CA8-62807FA6E9CA@microsoft.com...
: > : Roland,
: > : Thanks for verufying that. I am able to do this in Excel (My version
is
: > : Office Excel 2003 (11.6355.6360)), but when I am using vbsript to
generate
: > : chart from data, I am not able to get it. I tried several different
chart
: > : types, but to no avail. I tried the chart types that are available
here,
: > :
: >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/owcvba10/html/ocproDataSource.asp
: > :
: > : In that link, click on "Type property as it applies to the ChChart and
: > : ChSeries objects." and then click on the "ChartChartTypeEnum." I tried
the
: > : types listed there. But for some reason, wherever there is no value,
these
: > : chart types are defaulting to 0. Can you think of any other chart
types
: > that
: > : I missed that might be useful for this scenario?
: >
: > Showing some code would make it easier no this end. I looked in Excel
and
: > some types show the gaps and some do not. I'm assuming with this list
I'm
: > using chChartTypeLineStacked3D.
: >
: > ChartChartTypeEnum can be one of these ChartChartTypeEnum
constants.
:
:
: I was able to fix this issue using an article in Microsoft KB. Article ID
:
: 326103
:
: Just wanted to update in case anyone else might run into this same issue.
: One issue I had with this article was, it was not recognising NULL value
when
: passed in the string. So, whenever I got null values, I made it zero and
in
: the code I asked it no to draw a line if its zero.
:
: Sorry for delay in replying. Thanks for all the help.

No problem. One question. So, if the value of a column really is 0, I
assume not showing it is not an issue.

--
Roland Hall
/* This information is distributed in the hope that it will be useful, but
without any warranty; without even the implied warranty of merchantability
or fitness for a particular purpose. */
Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
MSDN Library - http://msdn.microsoft.com/library/default.asp

yarlagadda
Fri Sep 09 14:29:28 CDT 2005



"Roland Hall" wrote:

> "yarlagadda" wrote in message
> news:4635B82E-549C-43B8-A77C-48DCF392F5A3@microsoft.com...
> :
> :
> : "Roland Hall" wrote:
> :
> : > "yarlagadda" wrote in message
> : > news:5B73AF57-AC39-4726-8CA8-62807FA6E9CA@microsoft.com...
> : > : Roland,
> : > : Thanks for verufying that. I am able to do this in Excel (My version
> is
> : > : Office Excel 2003 (11.6355.6360)), but when I am using vbsript to
> generate
> : > : chart from data, I am not able to get it. I tried several different
> chart
> : > : types, but to no avail. I tried the chart types that are available
> here,
> : > :
> : >
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/owcvba10/html/ocproDataSource.asp
> : > :
> : > : In that link, click on "Type property as it applies to the ChChart and
> : > : ChSeries objects." and then click on the "ChartChartTypeEnum." I tried
> the
> : > : types listed there. But for some reason, wherever there is no value,
> these
> : > : chart types are defaulting to 0. Can you think of any other chart
> types
> : > that
> : > : I missed that might be useful for this scenario?
> : >
> : > Showing some code would make it easier no this end. I looked in Excel
> and
> : > some types show the gaps and some do not. I'm assuming with this list
> I'm
> : > using chChartTypeLineStacked3D.
> : >
> : > ChartChartTypeEnum can be one of these ChartChartTypeEnum
> constants.
> :
> :
> : I was able to fix this issue using an article in Microsoft KB. Article ID
> :
> : 326103
> :
> : Just wanted to update in case anyone else might run into this same issue.
> : One issue I had with this article was, it was not recognising NULL value
> when
> : passed in the string. So, whenever I got null values, I made it zero and
> in
> : the code I asked it no to draw a line if its zero.
> :
> : Sorry for delay in replying. Thanks for all the help.
>
> No problem. One question. So, if the value of a column really is 0, I
> assume not showing it is not an issue.
>
> --
> Roland Hall
> /* This information is distributed in the hope that it will be useful, but
> without any warranty; without even the implied warranty of merchantability
> or fitness for a particular purpose. */
> Technet Script Center - http://www.microsoft.com/technet/scriptcenter/
> WSH 5.6 Documentation - http://msdn.microsoft.com/downloads/list/webdev.asp
> MSDN Library - http://msdn.microsoft.com/library/default.asp
>
>
>

Luckily for these charts that I had to develop, there were not going to be
any values with 0. And even if there are any, the requirement was not to
display them. I guess, if there is any requirement to display them(zero
values), then setting the NULL value to some non numeric character would be
able to handle it :)

Prasad Yarlagadda