Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Hi, all I am trying to get some data in a graph with a primary and secondary
axis. One side would be the Percentage complete the other would show the times that the data was completed. I want to see the time and the percent on teh Y axis. And just have one bar Like a thermometer graph. The issue is I am pulling this data real time so as new orders come in it adds another row to the excel spreadsheet. I can drag this out to a max feild and still calculate but I can't figure out how to put it into a working graph. Here are the two feilds of data that I am trying to get into the graph. The CONFT field and the Percent complete field. I am not sure if this can be done but any ideas would be appreciated. Thanks CONFT Feild1 Count percent complete 0:00:00 0 0 0% 0:00:00 0 0 0% 0:00:00 0 0 0% 0:00:00 0 0 0% 0:00:00 0 0 0% 0:00:00 1 1 2% 7:32:57 2 1 4% 7:36:04 3 1 7% 7:50:53 4 1 9% 7:55:21 5 1 11% 7:57:00 6 1 13% 7:57:03 7 1 15% 8:00:49 8 1 17% 8:14:55 9 1 20% 8:16:06 10 1 22% |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Bar graph with percentage of total marked inside each bar | Charts and Charting in Excel | |||
percentage/figs on the same graph | Charts and Charting in Excel | |||
convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
show value as percentage in stacked bar graph | Charts and Charting in Excel | |||
Creating a stacked column chart with percentage in the graph | Charts and Charting in Excel |