Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table - Calc Item Problem | Excel Worksheet Functions | |||
Problem adding Series XValues to Chart using VBA | Charts and Charting in Excel | |||
Problem with times in pivot tables and graphs | Excel Discussion (Misc queries) | |||
CHARTING W/INDIRECT SERIES | Charts and Charting in Excel | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |