Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Removing specific data from a bar chart
Hi Group,
Hope someone can help me here. Here is my set up. In d3:e3 I have merged cells called North, f3:g3 South, h3:i3 East, j3:k3 West. In d4 I have a date 01/02/2005 and in e4 I have a date 01/03/2005. This date sequence is the same for South, East & West. In C4 I have a header called Sales. In cells C5:C34 I have names of Reps. In D5:k34 I have data containing sales made by Reps. To note: Reps sell goods in 1 area only but sometimes Reps will sell goods in 2 or 3 areas. I can produce a graph by area but Excel lists all reps for all areas. I would like Excel to detect and remove from the graph any sales which equal zero (no sales by Reps in that area) so that I get an accurate and better looking graph as my current one looks like black lines. Hope this makes sense. Regards Tony |
#2
|
|||
|
|||
Tony -
Is this what you need to do: http://peltiertech.com/Excel/Charts/SqueezeColumns.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Tony wrote: Hi Group, Hope someone can help me here. Here is my set up. In d3:e3 I have merged cells called North, f3:g3 South, h3:i3 East, j3:k3 West. In d4 I have a date 01/02/2005 and in e4 I have a date 01/03/2005. This date sequence is the same for South, East & West. In C4 I have a header called Sales. In cells C5:C34 I have names of Reps. In D5:k34 I have data containing sales made by Reps. To note: Reps sell goods in 1 area only but sometimes Reps will sell goods in 2 or 3 areas. I can produce a graph by area but Excel lists all reps for all areas. I would like Excel to detect and remove from the graph any sales which equal zero (no sales by Reps in that area) so that I get an accurate and better looking graph as my current one looks like black lines. Hope this makes sense. Regards Tony |
#3
|
|||
|
|||
Jon,
Yes, I need to remove the blank lines. Thanks for the link and example on your page. Neat solution. Cheers Tony -----Original Message----- Tony - Is this what you need to do: http://peltiertech.com/Excel/Charts/SqueezeColumns.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Tony wrote: Hi Group, Hope someone can help me here. Here is my set up. In d3:e3 I have merged cells called North, f3:g3 South, h3:i3 East, j3:k3 West. In d4 I have a date 01/02/2005 and in e4 I have a date 01/03/2005. This date sequence is the same for South, East & West. In C4 I have a header called Sales. In cells C5:C34 I have names of Reps. In D5:k34 I have data containing sales made by Reps. To note: Reps sell goods in 1 area only but sometimes Reps will sell goods in 2 or 3 areas. I can produce a graph by area but Excel lists all reps for all areas. I would like Excel to detect and remove from the graph any sales which equal zero (no sales by Reps in that area) so that I get an accurate and better looking graph as my current one looks like black lines. Hope this makes sense. Regards Tony . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
changing proportion of chart and data table | Charts and Charting in Excel | |||
Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel |