Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default interactive charts for stacked bar charts

I have been able to create/reproduce xy charts that use the offset()
function to vary the x axis. I am not sure how to do this with a
stacked bar chart when the y axis is based on several different
columns. Any help would be appreciated.

Data

X Y
Finger(s) - Puncture, 1,0,0,0,0
Hand - Avulsion, 0,1,0,0,0
Thumb - Laceration, 1,0,1,0,0
Finger(s) - Laceration, 1,0,0,1,1
Lower Leg - Laceration, 1,0,1,1,0
Ear(s) - HearLoss, 1,0,1,0,0

Thanks,

JCANTU

  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default interactive charts for stacked bar charts

You can't use a dynamic range to alter the number of series in a chart, only
the number of points in each series.

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


wrote in message
ups.com...
I have been able to create/reproduce xy charts that use the offset()
function to vary the x axis. I am not sure how to do this with a
stacked bar chart when the y axis is based on several different
columns. Any help would be appreciated.

Data

X Y
Finger(s) - Puncture, 1,0,0,0,0
Hand - Avulsion, 0,1,0,0,0
Thumb - Laceration, 1,0,1,0,0
Finger(s) - Laceration, 1,0,0,1,1
Lower Leg - Laceration, 1,0,1,1,0
Ear(s) - HearLoss, 1,0,1,0,0

Thanks,

JCANTU



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default interactive charts for stacked bar charts

just so that i am clear, if i included all of the potential series;
then I could alter the number of points in each series based on the
offset() individually but would have extra series that may not have any
data on the chart. i'll have to check and see if this will work for
us. thanks for the quick response.


Jon Peltier wrote:
You can't use a dynamic range to alter the number of series in a chart, only
the number of points in each series.

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


wrote in message
ups.com...
I have been able to create/reproduce xy charts that use the offset()
function to vary the x axis. I am not sure how to do this with a
stacked bar chart when the y axis is based on several different
columns. Any help would be appreciated.

Data

X Y
Finger(s) - Puncture, 1,0,0,0,0
Hand - Avulsion, 0,1,0,0,0
Thumb - Laceration, 1,0,1,0,0
Finger(s) - Laceration, 1,0,0,1,1
Lower Leg - Laceration, 1,0,1,1,0
Ear(s) - HearLoss, 1,0,1,0,0

Thanks,

JCANTU


  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default interactive charts for stacked bar charts

This would leave a legend entry, even if the series had no points.

What I do with this kind of series is point to an empty range, rather than
try to define a range of zero cells.

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


wrote in message
oups.com...
just so that i am clear, if i included all of the potential series;
then I could alter the number of points in each series based on the
offset() individually but would have extra series that may not have any
data on the chart. i'll have to check and see if this will work for
us. thanks for the quick response.


Jon Peltier wrote:
You can't use a dynamic range to alter the number of series in a chart,
only
the number of points in each series.

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


wrote in message
ups.com...
I have been able to create/reproduce xy charts that use the offset()
function to vary the x axis. I am not sure how to do this with a
stacked bar chart when the y axis is based on several different
columns. Any help would be appreciated.

Data

X Y
Finger(s) - Puncture, 1,0,0,0,0
Hand - Avulsion, 0,1,0,0,0
Thumb - Laceration, 1,0,1,0,0
Finger(s) - Laceration, 1,0,0,1,1
Lower Leg - Laceration, 1,0,1,1,0
Ear(s) - HearLoss, 1,0,1,0,0

Thanks,

JCANTU




  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default interactive charts for stacked bar charts

To hide a series and legend entry, you could set up an autofilter (if the
series were arranged by row in the worksheet), and use the autofilter to
hide rows you didn't want to plot.

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


"Jon Peltier" wrote in message
...
This would leave a legend entry, even if the series had no points.

What I do with this kind of series is point to an empty range, rather than
try to define a range of zero cells.

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


wrote in message
oups.com...
just so that i am clear, if i included all of the potential series;
then I could alter the number of points in each series based on the
offset() individually but would have extra series that may not have any
data on the chart. i'll have to check and see if this will work for
us. thanks for the quick response.


Jon Peltier wrote:
You can't use a dynamic range to alter the number of series in a chart,
only
the number of points in each series.

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


wrote in message
ups.com...
I have been able to create/reproduce xy charts that use the offset()
function to vary the x axis. I am not sure how to do this with a
stacked bar chart when the y axis is based on several different
columns. Any help would be appreciated.

Data

X Y
Finger(s) - Puncture, 1,0,0,0,0
Hand - Avulsion, 0,1,0,0,0
Thumb - Laceration, 1,0,1,0,0
Finger(s) - Laceration, 1,0,0,1,1
Lower Leg - Laceration, 1,0,1,1,0
Ear(s) - HearLoss, 1,0,1,0,0

Thanks,

JCANTU






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interactive Charts daigle Charts and Charting in Excel 4 May 24th 06 06:11 PM
Pasting worksheet with embedded charts FishMan Charts and Charting in Excel 2 October 5th 05 02:26 PM
Excel Charts Linked to Spreadsheets Rich Charts and Charting in Excel 1 July 4th 05 04:36 PM
linkingof charts in worksheets to cells steve Excel Discussion (Misc queries) 0 May 6th 05 01:44 AM
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB kathy in kansas Excel Discussion (Misc queries) 0 January 24th 05 08:47 PM


All times are GMT +1. The time now is 07:01 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"