Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
nsv
 
Posts: n/a
Default Labels and Dummy Series


On the site

http://peltiertech.com/Excel/Charts/GanttChart.html

are given some examples of how to make arbitrary gridlines (no problem)
with labels (big problem). One of the examples is called Livestock, and
here is given an instruction:

"Add labels in 'Label' column to dummy series added above"

but no clue whatsoever on HOW to do it, which i find pretty strange as
this is exactly what the whole show is all about.

Can anyone give a hint?


NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=476798

  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default Labels and Dummy Series

Let me check the example. It should be telling you to download one of
these free and very useful chart labeling add-ins:

Rob Bovey's Chart Labeler, http://appspro.com
John Walkenbach's Chart Tools, http://j-walk.com/ss

Both are pretty much self-explanatory.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


nsv wrote:

On the site

http://peltiertech.com/Excel/Charts/GanttChart.html

are given some examples of how to make arbitrary gridlines (no problem)
with labels (big problem). One of the examples is called Livestock, and
here is given an instruction:

"Add labels in 'Label' column to dummy series added above"

but no clue whatsoever on HOW to do it, which i find pretty strange as
this is exactly what the whole show is all about.

Can anyone give a hint?


NSV


  #3   Report Post  
nsv
 
Posts: n/a
Default Labels and Dummy Series


OK, I have not found that about downloading the Add-in, but I did that
and now it works. Thank you!


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=476798

  #4   Report Post  
nsv
 
Posts: n/a
Default Labels and Dummy Series


It works perfectly, thanks for the tip.

Around ten years ago this was easily done in Lotus 123. Working in a
test and development department I made myself a chart to follow a
Weibull distributed failure development, just as your example with the
probability chart. After we were forced to change to Excel it has
annoyed me, that I could only make this chart in an awfully clumsy
manner with a textbox containing the labels.


NSV


--
nsv
------------------------------------------------------------------------
nsv's Profile: http://www.excelforum.com/member.php...o&userid=26500
View this thread: http://www.excelforum.com/showthread...hreadid=476798

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
scatter chart x axis problem Suzan Charts and Charting in Excel 4 April 2nd 23 07:57 PM
Stock High-Low-Close Chart Tim Charts and Charting in Excel 7 August 24th 07 01:02 PM
Conditional Datalabel formating Karl Charts and Charting in Excel 2 September 21st 05 01:00 AM
labels in formulas C New Users to Excel 5 January 18th 05 03:15 PM
Y axis, need varying units NTE Charts and Charting in Excel 10 December 13th 04 06:34 PM


All times are GMT +1. The time now is 08:07 AM.

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"