LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default Error bars plot black triangles

In Excel 2007, when I try to plot vertical error bars on a chart with no zero
or negative values it gives me the standard error that "Negative or zero
values cannot be plotted correctly on log charts." Then when it actually
graphs the data there are strange black triangles stretching across the chart
that should not be there. I know that if I uncheck the "logarithmic" box it
will show correctly, but the x-axis needs to be logarithmic for this to work
for what I need.

There is another thread here that I am aware of but the solution that worked
for that person did not work for me, so I am looking to see if someone else
has come up with another option. Just a note, in the 2003 version of Excel,
when there are "Negative or zero" data points it just doesn't show anything
on the chart for them so there are no black triangles. Thanks for your help.
 
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
Can a combo chart plot 4 variables? (3 bars,1 line) [email protected] Charts and Charting in Excel 1 June 20th 06 01:41 PM
How do I plot mean and error bars in Excel? rik827 Charts and Charting in Excel 1 June 16th 06 11:58 PM
How do I plot negative bars/numbers BELOW the main axis in Excel Maciel Charts and Charting in Excel 1 March 10th 06 01:27 AM
How do I plot error bars on 3D graphs? jho105 Charts and Charting in Excel 1 May 5th 05 09:36 AM
Convert diagram bars to black and white Detfunkar Charts and Charting in Excel 1 January 15th 05 09:23 AM


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

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

About Us

"It's about Microsoft Excel"