|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-29-2008, 09:33 AM
|
|||
|
|||
Stacked Column Chart
I need to graph quartiles with the 3rd and 4th quartile falling below the 50th %ile line. The only way I can do this is to make the 3rd and 4th quartile be a negative #, but I do not want to have the negative sign displayed. Is there any way I can do this besides going into each data value on the chart and deleting the -sign? Because if I do that, the numbers will not update. In the attachment the first chart is what results when I create the chart, but the 2nd chart is how I would like it to look.
|
|
#3
08-31-2008, 07:30 AM
|
||||
|
||||
|
Detailed instructions
Select datalabels of series "Third Quartile" CTRL+1 to display Format dialog On Number tab select category Custom In the Type box enter, General;General;General repeat for Forth Quartile series.
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Increasing and decreasing depending of column C | caldera55 | Excel Worksheet Functions | 0 | 06-25-2008 07:33 PM |
| Data Points within a stacked column chart | DBMcH | Excel Charting | 9 | 05-15-2008 03:39 PM |
| Can I get a chart to update a new column added? | gshock | Excel General | 2 | 04-19-2008 02:19 PM |
| stacked column/bar chart w/ monthly data + single line of daily data | dommarsh | Excel Charting | 1 | 04-07-2008 12:29 AM |
| Can this Stacked Chart be Done ?? | robertguy | Excel Charting | 1 | 06-15-2007 09:49 AM |
Linear Mode
