Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default 3 columns and one line chart

Hello!
I'm trying to create a chart from 4 rows of data. I need the first
three rows to be columns and the last row to be displayed as a line.
If I set my chart type to "line - column", I get the first 2 rows as
columns and the last 2 rows as lines.

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 3 columns and one line chart

Nevermind, I figured it out. I made a column chart and then selected
the column series I wanted as a line. Then I right-moused and selected
the line chart I wanted and ,viola!, 3 columns and 1 line!

On Thu, 11 Dec 2003 10:49:13 -0800, Terry Carpenter
wrote:

Hello!
I'm trying to create a chart from 4 rows of data. I need the first
three rows to be columns and the last row to be displayed as a line.
If I set my chart type to "line - column", I get the first 2 rows as
columns and the last 2 rows as lines.

Thanks!


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
Combination chart: 3 stacked columns + 1 line Lancecar Charts and Charting in Excel 1 October 21st 06 04:06 PM
line-column combination chart, with stacked columns annewcpss Charts and Charting in Excel 1 June 5th 06 08:51 PM
create a chart using two columns for x & y, third for line data Ted K Charts and Charting in Excel 3 November 11th 05 01:39 AM
how do I create a chart on two axes with stacked columns and line ian ian ian rogers Charts and Charting in Excel 1 May 20th 05 11:32 AM
I want to draw a line through the columns of a chart, plot the o. Dewey Charts and Charting in Excel 1 April 15th 05 12:24 AM


All times are GMT +1. The time now is 09:06 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"