ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How to plot bands in excel (https://www.excelbanter.com/charts-charting-excel/222801-how-plot-bands-excel.html)

Mangesh

How to plot bands in excel
 
Hello All,
I want to plot a graph that sholud show different bands of ranges
ex.
A B C
N1 12 35
N2 10 40
N3 71 95
N4 09 12

Now i want to ploa a graph that shold show N1,N2-N4's ranges in bands
so on x axis i'll have N1-N4.
how should i plot Y axis


Thanks for you co operation.
Mangesh

Bernard Liengme[_3_]

How to plot bands in excel
 
Not sure I follow but it would seem you need to select all three columns of
data and make a Line chart
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mangesh" wrote in message
...
Hello All,
I want to plot a graph that sholud show different bands of ranges
ex.
A B C
N1 12 35
N2 10 40
N3 71 95
N4 09 12

Now i want to ploa a graph that shold show N1,N2-N4's ranges in bands
so on x axis i'll have N1-N4.
how should i plot Y axis


Thanks for you co operation.
Mangesh





All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com