Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to draw an line chart starting at column 1
Hello,
I want to draw a line chart that looks like the following | + | + | + | + | + |________ | | | | 1 2 3 4 How can I do that? It always looks like that: | + | + | + | + | + |________ | | | | 1 2 3 4 Greets Xaver |
#2
|
|||
|
|||
Hi,
Double click the x axis and on the scale tab uncheck the "Value (Y) axis crosses between categories". Cheers Andy Xaver Hinterhuber wrote: Hello, I want to draw a line chart that looks like the following | + | + | + | + | + |________ | | | | 1 2 3 4 How can I do that? It always looks like that: | + | + | + | + | + |________ | | | | 1 2 3 4 Greets Xaver -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
You have made a Line chart when you seem to need an XY chart
best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Xaver Hinterhuber" wrote in message ... Hello, I want to draw a line chart that looks like the following | + | + | + | + | + |________ | | | | 1 2 3 4 How can I do that? It always looks like that: | + | + | + | + | + |________ | | | | 1 2 3 4 Greets Xaver |
#4
|
|||
|
|||
Hello Andy,
if I uncheck "Value (Y) axis crosses between categories", then I get the following line chart: | + | + | + + |________ | | | | 1 2 3 4 But I want the line chart to start at "2". Greets Xaver "Andy Pope" schrieb im Newsbeitrag ... Hi, Double click the x axis and on the scale tab uncheck the "Value (Y) axis crosses between categories". Cheers Andy Xaver Hinterhuber wrote: Hello, I want to draw a line chart that looks like the following | + | + | + | + | + |________ | | | | 1 2 3 4 How can I do that? It always looks like that: | + | + | + | + | + |________ | | | | 1 2 3 4 Greets Xaver -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
|
|||
|
|||
Hello Bernard,
thanks. Your tip works as expected. I've got one additional wish. I want the first label to disappear. So the chart looks like this: | + | + | + | + | + |________ | | | 2 3 4 Is this possible? "Bernard Liengme" schrieb im Newsbeitrag ... You have made a Line chart when you seem to need an XY chart best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Xaver Hinterhuber" wrote in message ... Hello, I want to draw a line chart that looks like the following | + | + | + | + | + |________ | | | | 1 2 3 4 How can I do that? It always looks like that: | + | + | + | + | + |________ | | | | 1 2 3 4 Greets Xaver |
#6
|
|||
|
|||
Hi,
Then as Bernard pointed out you need to use the XY scatter chart and then Set the scales Min value to 2. Cheers Andy Xaver Hinterhuber wrote: Hello Andy, if I uncheck "Value (Y) axis crosses between categories", then I get the following line chart: | + | + | + + |________ | | | | 1 2 3 4 But I want the line chart to start at "2". Greets Xaver "Andy Pope" schrieb im Newsbeitrag ... Hi, Double click the x axis and on the scale tab uncheck the "Value (Y) axis crosses between categories". Cheers Andy Xaver Hinterhuber wrote: Hello, I want to draw a line chart that looks like the following | + | + | + | + | + |________ | | | | 1 2 3 4 How can I do that? It always looks like that: | + | + | + | + | + |________ | | | | 1 2 3 4 Greets Xaver -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
how to show date on the x axis of a line chart? | Charts and Charting in Excel | |||
How do I combine a line and a percentage stacked column chart? | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |