ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Problem with series when charting from a pivot table (https://www.excelbanter.com/charts-charting-excel/20937-problem-series-when-charting-pivot-table.html)

Dan

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!

Dan

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