PC Review


Reply
Thread Tools Rate Thread

column graphs

 
 
Jo
Guest
Posts: n/a
 
      4th May 2004
Hi
How do I make a XY type column graph? I wish to add data
to a column graph and have it plotted at the correct X
interval
Thanks
Jo
 
Reply With Quote
 
 
 
 
=?Utf-8?B?VHVzaGFyIE1laHRh?=
Guest
Posts: n/a
 
      4th May 2004
There's no easy way that I know of.

One option is to create enough empty spaces (rows) to get the correct effect. So, to plot x values of 1, 5 and 20, put the values in row 1, 5 and 20, leaving the other rows empty. Put the corresponding y values in the same rows (1, 5, 20).

Alternatively, create a XY Scatter chart and use a y error bar. Make it a 100% negative value bar. Format it for best effect, though about the best one can get is a thick line.

"Jo" wrote:

> Hi
> How do I make a XY type column graph? I wish to add data
> to a column graph and have it plotted at the correct X
> interval
> Thanks
> Jo
>

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can you get Column graphs to be next to each other instead ofspaced apart? simonlavender@gmail.com Microsoft Excel Charting 2 17th Feb 2009 03:23 PM
How do I combine stacked column and single column graphs? =?Utf-8?B?QWxm?= Microsoft Excel Misc 0 24th Feb 2006 12:29 AM
Column Graphs =?Utf-8?B?bGtlZ2xleQ==?= Microsoft Excel Charting 1 21st Nov 2005 10:46 PM
Line Column Graphs Andy Microsoft Excel Charting 1 3rd Feb 2005 10:20 AM
Stacked Column Graphs Robert Microsoft Excel Charting 1 9th Feb 2004 07:38 PM


Features
 

Advertising
 

Newsgroups
 


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