|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
08-15-2008, 04:30 PM
|
|||
|
|||
|
Chart source data puzzle
What I have: I inherited a chart and table that I am required to use. The chart is supposed to display table values and percentage. As the table and chart is now, values have to be manually entered into the table then the chart with each new use. Table data isn't linked to the chart. I tried to figure out how the percentages are calculated without success.
What I need: I would like to enter Occupied hours in the table and display those hours and the unoccupied hours in the chart with the percentage each value is of 168 hours. 
|
|
#2
08-15-2008, 05:04 PM
|
||||
|
||||
|
All you need to do is change the input of the data into the chart. To do this, right click on the chart and hit Select Data. From there, select the only range of values that you are plotting and replace it with the two cells that have the values in it. Here's what the finished product should look like.
|
|
#4
08-16-2008, 11:34 AM
|
||||
|
||||
|
The merged cells mean you need to change your chart data source to these references.
Value: =(Sheet1!$B$4,Sheet1!$D$4) Category Labels: =(Sheet1!$B$3,Sheet1!$D$3) Excel is not on strike you have Calculation set to manual. press F9
|
 |
| 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 |
|
|
Linear Mode
