Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 14th 06, 04:49 AM posted to microsoft.public.excel.charting
Mike
 
Posts: n/a
Default Column Chart - X axis too thin because of MANY categories.

I'm brand new to Pivot Charts and trying to figure out what I thought
would be simple: I have a Column Chart with $Sales for the Y axis and
Salesperson on the X(category) axis. There are hundreds of
salespeople, which results in the chart displaying extremely thin lines
with totally unreadable category labels( salesperson initials). Is
there not a way to specifiy a gap between categories on the X axis? Or
some way to space them apart and be able to scroll the chart
horizontally? I have a feeling you are all going to tell me scrolling
is just a dream

TIA,

-Mike


  #2   Report Post  
Old June 14th 06, 05:40 PM posted to microsoft.public.excel.charting
Mike
 
Posts: n/a
Default Column Chart - X axis too thin because of MANY categories.

Hmmm, no replies. Maybe I posted in an inappropriate forum?


Mike wrote:
I'm brand new to Pivot Charts and trying to figure out what I thought
would be simple: I have a Column Chart with $Sales for the Y axis and
Salesperson on the X(category) axis. There are hundreds of
salespeople, which results in the chart displaying extremely thin lines
with totally unreadable category labels( salesperson initials). Is
there not a way to specifiy a gap between categories on the X axis? Or
some way to space them apart and be able to scroll the chart
horizontally? I have a feeling you are all going to tell me scrolling
is just a dream

TIA,

-Mike


  #3   Report Post  
Old June 15th 06, 08:57 AM posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Column Chart - X axis too thin because of MANY categories.

Hi,

Scrolling the pivot chart will be. But you could create your own chart
based on the pivot table which can be scrolled.
You need to create a dynamic chart using named ranges. Here is a
collection of links on the topic.
http://peltiertech.com/Excel/Charts/...hartLinks.html

And I have a scrolling example here
http://www.andypope.info/charts/Scrolling.htm

Cheers
Andy

Mike wrote:
Hmmm, no replies. Maybe I posted in an inappropriate forum?


Mike wrote:

I'm brand new to Pivot Charts and trying to figure out what I thought
would be simple: I have a Column Chart with $Sales for the Y axis and
Salesperson on the X(category) axis. There are hundreds of
salespeople, which results in the chart displaying extremely thin lines
with totally unreadable category labels( salesperson initials). Is
there not a way to specifiy a gap between categories on the X axis? Or
some way to space them apart and be able to scroll the chart
horizontally? I have a feeling you are all going to tell me scrolling
is just a dream

TIA,

-Mike




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
  #4   Report Post  
Old June 15th 06, 01:18 PM posted to microsoft.public.excel.charting
Mike
 
Posts: n/a
Default Column Chart - X axis too thin because of MANY categories.

Thanks Andy, I will check out that link...

I am still quite amazed that Microsoft made such a potentially powerful
tool(pivot charts) so limited. My scenario of salespeople(or any
category) along the x-axis, and sales dollars along the y-axis seems so
commonplace. Yet try to display more than about 50 categories along
the x-axis and you have a pretty much useless chart Maybe I am the
first person to want to do what seems like such a simple pivot chart
application? I doubt it Hopefully Microsoft will add a zoom or
scroll feature in future versions...


Andy Pope wrote:
Hi,

Scrolling the pivot chart will be. But you could create your own chart
based on the pivot table which can be scrolled.
You need to create a dynamic chart using named ranges. Here is a
collection of links on the topic.
http://peltiertech.com/Excel/Charts/...hartLinks.html

And I have a scrolling example here
http://www.andypope.info/charts/Scrolling.htm

Cheers
Andy

Mike wrote:
Hmmm, no replies. Maybe I posted in an inappropriate forum?


Mike wrote:

I'm brand new to Pivot Charts and trying to figure out what I thought
would be simple: I have a Column Chart with $Sales for the Y axis and
Salesperson on the X(category) axis. There are hundreds of
salespeople, which results in the chart displaying extremely thin lines
with totally unreadable category labels( salesperson initials). Is
there not a way to specifiy a gap between categories on the X axis? Or
some way to space them apart and be able to scroll the chart
horizontally? I have a feeling you are all going to tell me scrolling
is just a dream

TIA,

-Mike




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info




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
Category axis label problem at column chart Marko Pinteric Charts and Charting in Excel 9 April 24th 06 02:40 PM
How do I do a combination STACKED column and line chart on 2 axis rwtuning Charts and Charting in Excel 1 April 18th 06 10:02 PM
Conditional Format as a MACRO Gunjani Excel Worksheet Functions 3 March 29th 06 05:22 PM
hide column but show chart Svetlana Charts and Charting in Excel 1 January 14th 05 10:49 AM
Copying the contents of a column into a chart Richard Excel Worksheet Functions 1 November 16th 04 03:39 PM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017