Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 26
Default Adding a Second and Third Line to an Existing Stacked Bar/Line Cha

I have an existing stacked bar chart with the left Y-axis as the bar amounts
combined with a line with the line amounts displayed on the right Y-axis. I
want to add 2 more lines to my chart. When I add them as new series I do not
get anything displaying on my chart. The ranges are all okay. What am I
doing wrong?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Adding a Second and Third Line to an Existing Stacked Bar/Line Cha

Are the added series listed in the Source Data dialog Series tab? if so,
they may be plotted as the incorrect type or against the wrong axes. You can
select a series even if it's somehow obscured by selecting another series
and cycling through series using the up and down arrow keys. Once it's
selected, a series can be moved between primary and secondary axes, and you
can change its type.

Another thing to check is whether you have numerical data in the source data
range for the added series. If the added data is nonnumeric, Excel will not
be able to plot them.

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



"billbrandi" wrote in message
...
I have an existing stacked bar chart with the left Y-axis as the bar
amounts
combined with a line with the line amounts displayed on the right Y-axis.
I
want to add 2 more lines to my chart. When I add them as new series I do
not
get anything displaying on my chart. The ranges are all okay. What am I
doing wrong?



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 26
Default Adding a Second and Third Line to an Existing Stacked Bar/Line

All of the series show in the dialog box; I have 3 series of data that are
formatted as a stacked bar chart, and three series that are formatted as line
charts. Only one of the lines is showing-the other two are not.

"Jon Peltier" wrote:

Are the added series listed in the Source Data dialog Series tab? if so,
they may be plotted as the incorrect type or against the wrong axes. You can
select a series even if it's somehow obscured by selecting another series
and cycling through series using the up and down arrow keys. Once it's
selected, a series can be moved between primary and secondary axes, and you
can change its type.

Another thing to check is whether you have numerical data in the source data
range for the added series. If the added data is nonnumeric, Excel will not
be able to plot them.

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



"billbrandi" wrote in message
...
I have an existing stacked bar chart with the left Y-axis as the bar
amounts
combined with a line with the line amounts displayed on the right Y-axis.
I
want to add 2 more lines to my chart. When I add them as new series I do
not
get anything displaying on my chart. The ranges are all okay. What am I
doing wrong?




  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Adding a Second and Third Line to an Existing Stacked Bar/Line

Do the data ranges for the lines that don't appear contain real numerical
data?

Select a series. Use the up and down arrow keys to cycle among the series.
Can the series that don't appear be selected in this way?

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


"billbrandi" wrote in message
...
All of the series show in the dialog box; I have 3 series of data that are
formatted as a stacked bar chart, and three series that are formatted as
line
charts. Only one of the lines is showing-the other two are not.

"Jon Peltier" wrote:

Are the added series listed in the Source Data dialog Series tab? if
so,
they may be plotted as the incorrect type or against the wrong axes. You
can
select a series even if it's somehow obscured by selecting another series
and cycling through series using the up and down arrow keys. Once it's
selected, a series can be moved between primary and secondary axes, and
you
can change its type.

Another thing to check is whether you have numerical data in the source
data
range for the added series. If the added data is nonnumeric, Excel will
not
be able to plot them.

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



"billbrandi" wrote in message
...
I have an existing stacked bar chart with the left Y-axis as the bar
amounts
combined with a line with the line amounts displayed on the right
Y-axis.
I
want to add 2 more lines to my chart. When I add them as new series I
do
not
get anything displaying on my chart. The ranges are all okay. What am
I
doing wrong?






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
average Line created in an existing line graph- based on one cell Melanie Charts and Charting in Excel 2 December 27th 07 10:14 PM
adding a line to an existing chart JudyT Charts and Charting in Excel 2 August 6th 07 04:26 PM
Adding a line to the line/column chart? Steven Charts and Charting in Excel 2 February 12th 07 10:46 PM
Chart Type - Line Column adding a 2nd line [email protected] Charts and Charting in Excel 1 October 24th 06 04:17 PM
Adding a line Chart Type to a stacked-clustered Chart Type Debbie Charts and Charting in Excel 2 January 6th 05 12:25 AM


All times are GMT +1. The time now is 01:31 PM.

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"