If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Chart
Hello,
I have a following chart problem: Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Age 10 20 30 40 50 60 40 50 30 N/A N/A N/A Pops 20 30 40 50 60 70 40 45 89 How can I create linechart so that POps data starts showing beginning from Apr. I tried doing it but it always takes Pops data starting January. Any tips will be highly appreciated.Thanks Sanj |
#2
|
|||
|
|||
Chart
Sanj -
I suspect your series formula has the Pops data starting with the April value, not the January blank. To make the chart from scratch, first clear the cell that now says "Month". The blank helps Excel choose the data range. Select the entire range, or a single cell within the range, and run the chart wizard. Jan-Dec are the category axis labels, Age is charted from Jan to Sep, and Pops from Apr to Dec. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ Sanj wrote: Hello, I have a following chart problem: Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Age 10 20 30 40 50 60 40 50 30 N/A N/A N/A Pops 20 30 40 50 60 70 40 45 89 How can I create linechart so that POps data starts showing beginning from Apr. I tried doing it but it always takes Pops data starting January. Any tips will be highly appreciated.Thanks Sanj |
#3
|
|||
|
|||
Chart
Sanj wrote:
Hello, I have a following chart problem: Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Age 10 20 30 40 50 60 40 50 30 N/A N/A N/A Pops 20 30 40 50 60 70 40 45 89 How can I create linechart so that POps data starts showing beginning from Apr. I tried doing it but it always takes Pops data starting January. Any tips will be highly appreciated.Thanks Sanj I suggest an XY scatter chart rather than a line chart. Use the Month row as your x-axis values in both series. Dave dvt at psu dot edu |
Thread Tools | |
Display Modes | |
|
|