Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Show series name on the chart - but not at every data point | Charts and Charting in Excel | |||
Do not show a portion of the data series if the value is 0 | Charts and Charting in Excel | |||
adding a line to show average for a data series on a chart | Charts and Charting in Excel | |||
How to set up pivot to show name of series item in bar chart | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel |