LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default How to show 5 data series on one chart

Hello,

Here are the data that I have:
- a category that will be my X axis
- a percentage that will be my Y axis. I have a percentage value per
category per year.
- 3 company names
- 2 years (2004 and 2009)

What I want to show is the following:
For each company, I would like to plot a solid colored line representing the
different % for each category for 2004 and a dotted colored (same) line
representing different % for each category for 2009.

As a result I would get three sets of lines, three different colors, and
within each set a solid and a dotted line.

I currently have my table organized as follows:
Company1 Company2 Company3
2004 2009 2004 2009 2004 2009
Category-a 10% 15% 5% 3% ETC.
Category-b
Category-c

I hope I have put enough information for you to help me out.
Thanks in advance
Stephanie

 
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
Show series name on the chart - but not at every data point RSunday Charts and Charting in Excel 4 April 28th 23 07:43 PM
Do not show a portion of the data series if the value is 0 asmithbcat Charts and Charting in Excel 1 October 21st 08 10:06 PM
adding a line to show average for a data series on a chart Judy Rose Charts and Charting in Excel 1 August 22nd 08 10:01 PM
How to set up pivot to show name of series item in bar chart Lin, PMP, NJ Charts and Charting in Excel 0 November 28th 07 04:14 PM
chart data series -- plot a table as a single series hjc Charts and Charting in Excel 7 September 20th 05 05:52 PM


All times are GMT +1. The time now is 12:14 AM.

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

About Us

"It's about Microsoft Excel"