Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Charts
I have created numerous bar chart with VBA using data imported from SQL, the
charts are on a log scale. As log scales won't allow zero values, I get the following error when going to view the chart: Negative or zero values can not be plotted correctly on log chart...... Can I turn off the above warning, I tried application.setwarnings=False but this was to no avail, can anyone advise ? Also can any advise how to turn the coners of the chart to curves ? Regards John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Charts
If you are getting the warning, I assume it is because you have some values
that are zero or negative, so you have (in essence) an error condition. The way to get rid of the message is to fix the data so there are no zero/negative values. If the zero/negatives are valid data points, then (of necessity) a log scale is inappropriate for the data. -- - K Dales "John" wrote: I have created numerous bar chart with VBA using data imported from SQL, the charts are on a log scale. As log scales won't allow zero values, I get the following error when going to view the chart: Negative or zero values can not be plotted correctly on log chart...... Can I turn off the above warning, I tried application.setwarnings=False but this was to no avail, can anyone advise ? Also can any advise how to turn the coners of the chart to curves ? Regards John |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
charts toolbar / charts disappeared | Charts and Charting in Excel | |||
link excel charts to web pages and update charts automatically | Charts and Charting in Excel | |||
Charts - How to have multiple charts share a legend. | Charts and Charting in Excel | |||
interactive charts for stacked bar charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel |