![]() |
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! |
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! |
All times are GMT +1. The time now is 04:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com