Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Dan
 
Posts: n/a
Default Problem with series when charting from a pivot table

I have a pivot table with 1st column heading "Model" listing car models
beneath. The next column Headings are in years; 1988, 1999,..2005. In each
year column is a count of car models for the model listed in the first column.
I want to chart the model count (ver axis) vs year (hor axis), resulting in
a line for each model (6 models=six lines) showing the particular model count
for each year.
I did it yesterday and I am unable to reproduce it today. Help!
  #2   Report Post  
Dan
 
Posts: n/a
Default

I figgered it out...
1. copy/paste table
2. remove the "model" column header
3. chart

Thanks anyway!

"Dan" wrote:

I have a pivot table with 1st column heading "Model" listing car models
beneath. The next column Headings are in years; 1988, 1999,..2005. In each
year column is a count of car models for the model listed in the first column.
I want to chart the model count (ver axis) vs year (hor axis), resulting in
a line for each model (6 models=six lines) showing the particular model count
for each year.
I did it yesterday and I am unable to reproduce it today. Help!

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
Pivot Table - Calc Item Problem Scott Excel Worksheet Functions 2 June 2nd 05 01:53 AM
Problem adding Series XValues to Chart using VBA Sean Curry Charts and Charting in Excel 0 March 14th 05 12:18 AM
Problem with times in pivot tables and graphs [email protected] Excel Discussion (Misc queries) 2 February 23rd 05 06:59 AM
CHARTING W/INDIRECT SERIES Ronbo Charts and Charting in Excel 3 January 3rd 05 05:17 PM
Problem with Pivot Table Drop-Down Menus Mac Excel Worksheet Functions 4 November 7th 04 01:18 PM


All times are GMT +1. The time now is 07:20 PM.

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"