I have a question on drawing bar graphs. I have calculated CAPEX and OPEX prices with a max point and a min point. Now I want Excel to produce a graph that shows the min point as the minimum and than a bar up to the max point with a point for normal CAPEX/OPEX. Is this possible?
Hello,
I am trying to chart some data that contains events that last for a random duration. Lets say I have some data like this (for 20 seconds):
seconds, value
0 OFF
1 OFF
2 OFF
3 ON
4 ON
5 ON
6 OFF
7 OFF
8 ON
9 ON
10 ON
11 ON
12 ON
13 OFF
14 OFF
15 OFF
16 ON
17 ON
18 ON
19 ON
20 ON
It is kind...
Does anyone know how to change a 2-D bar chart to a 3-D bar chart? I tried clicking on the bars and then clicked into the 3-D settings in the drawing toolbar, but everything is grayed out. The 3-D settings option seems to be for drawing objects. I've also tried click on Chart Type, but I've had...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.