Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar Charts using data from =sum
Hi
I have created a Bar chart using data imported from another page, my problem is when I have no data in the cell the bar chart shows a Zero is there any way I can stop this happening Regards Kev |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar Charts using data from =sum
what do you want it to show?
"Bar chart shows Zero's" wrote: Hi I have created a Bar chart using data imported from another page, my problem is when I have no data in the cell the bar chart shows a Zero is there any way I can stop this happening Regards Kev |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar Charts using data from =sum
I want it to show nothing on the graph
"bj" wrote: what do you want it to show? "Bar chart shows Zero's" wrote: Hi I have created a Bar chart using data imported from another page, my problem is when I have no data in the cell the bar chart shows a Zero is there any way I can stop this happening Regards Kev |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar Charts using data from =sum
Have a look at Jon Peltier's advice at this google search thread.
http://snipurl.com/14ik0 Gord Dibben MS Excel MVP On Thu, 7 Dec 2006 13:32:01 -0800, Bar chart shows Zero''s wrote: I want it to show nothing on the graph "bj" wrote: what do you want it to show? "Bar chart shows Zero's" wrote: Hi I have created a Bar chart using data imported from another page, my problem is when I have no data in the cell the bar chart shows a Zero is there any way I can stop this happening Regards Kev |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar Charts using data from =sum
Does your X-Axis cross at zero?
anything except a true blank cell will show as a zero one thing I have done in this case is set up a secondary data set to graph from with something like =if(data cell = "", X axis cross value, data cell) "Bar chart shows Zero''s" wrote: I want it to show nothing on the graph "bj" wrote: what do you want it to show? "Bar chart shows Zero's" wrote: Hi I have created a Bar chart using data imported from another page, my problem is when I have no data in the cell the bar chart shows a Zero is there any way I can stop this happening Regards Kev |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Bar Charts using data from =sum
Change your formula to this:
=IF(Sheet2!A1+Sheet2!A2=0,"",Sheet2!A1+Sheet2!A2) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Bar chart shows Zero's" <Bar chart shows wrote in message ... Hi I have created a Bar chart using data imported from another page, my problem is when I have no data in the cell the bar chart shows a Zero is there any way I can stop this happening Regards Kev |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Manual control of link updating for downloaded quotes? | Excel Discussion (Misc queries) | |||
Charts - Align value & category data labels independently | Charts and Charting in Excel | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |